Dynamic Message for Action Button

[tm123]

Hi,

This is driving me crazy. I am using TM1 10.2.2, and I have built some websheets for data entry and I have also some action buttons that execute TI processes on the backend to recalculate / move data to other cubes.

In my TIs, I have written code to check for parameter values and other validation checks and if something is wrong I write a message in a 2-dimensional cube ( with one of dimensions being }Clients dim ). If the TI runs successfully, I write a message "Executed successfully" with some more details ( such as number of employees transferred etc ).
I have a DBR formula in my websheet where I read that message, and in my Action Button, in the Process Properties settings, I Link that Cell in the Return Message fields.

Well, in Perspectives everything works fine, but in TM1Web, the message is shown before the websheet is refreshed so it shows the old message. Is there a way to tell TM1Web to show the message after the websheet in recalculated ???

Thanks

[cipher]

hi TM123,

I also came across this issue couple of days back when I was creating Websheets on TM1 10.2.2.
The workaround is simple, use DBR function within the Success and Failure input message box. Like Below.

Process Options.jpg (34.71 KiB) Viewed 5179 times

For me it did work. You can give a try. This should work.

CiPH3R.

[lotsaram]

That's an awesome workaround (however awkward). It wouldn't have occurred to me to put an excel function directly into the parameter box. Still, not exactly something you would normally want to do.
@tm123 it sound like you're doing everything correct in terms of setting up the AB. If the AB is reading all param values from cell references pre-recalc at end of TI process and not post then this is a clear bug. Have either of you reported it as a bug and have a PMR or APAR reference?

[tm123]

I tried the same thing last night after i posted my question and it worked!!! I'm happy someone else has experienced this issue and has used this workaround. This was working fine in 10.2.0 but we upgraded this week to 10.2.2 and after that we started experiencing this issue. I am also having issues with SUBNM formulas not being able to select element. The element gets selected but if i use that element in an another excel formula to create an MDX statement, it does not work. It works if you open the websheet separately, but if you open it from a action button of another websheet from where you pass some parameters, then the excel cell that uses the subnm, does not get recalculated after i change my subnm selection. This is driving me crazy

[ThomasCS]

Hi All

I had the same issue when upgrading, but solved it with another workaround.
I put Calculate to "Rebuild Sheet" instead of "Auto Recalculate Sheet".

But, I think the workaround mentioned by Cipher is overall better for performance reasons compared to a sheet rebuild.