Page 1 of 1

Action button conditional navigation

Posted: Mon Jan 14, 2019 12:56 am
by mitch23
Have a rather perplexing problem. Need an action button to navigate to one of two other possible target sheets but need the target sheet to be conditionally determined based on the row element of the selected DBRW. I know this isn't natively supported so I have a VLOOKUP that will extract the target sheet name from the active row based on populating the Advanced tab to extract the selected row element into a cell which is then referenced by the VLOOKUP to return the target sheet. Unfortunately the native TM1 extraction of the selected row element doesn't occur until AFTER navigation occurs, thereby making it impossible for the VLOOKUP to extract the target sheet name before navigation.

Am at wits end and any suggestions would be greatly appreciated.

Re: Action button conditional navigation

Posted: Mon Jan 14, 2019 8:10 am
by declanr
Does the action button also need to run a process? And does the user need to be able to change the value in the dbrws in the source?

If the answer to both questions is no, then you can use the url api to make the dbrws hyperlinks - use the excel hyperlink formula - show the value as the display name and build a url api string for it.

Re: Action button conditional navigation

Posted: Mon Jan 14, 2019 9:11 am
by orlando
Hi,

maybe you could use an attribute on the row element to save the target filename.
or you use an lookup cube, that makes the VLOOKUP.
then you can read the attribute or the cube

regards,
orlando

Re: Action button conditional navigation

Posted: Mon Jan 21, 2019 12:41 pm
by karlblackler
Hi Orlando,

I usually use the CELL formula in conjunction with the OFFSET to get the current Row. And then store the application as an attribute of the row element.

In TM1Web there is a setting;
ActionButtonFullRecalculationEnabled
that needs to be set, else it doesn’t do the recalc beforehand.

Cheers
Karl