Action button conditional navigation

Post Reply
mitch23
Posts: 21
Joined: Thu Jan 29, 2009 11:32 am
OLAP Product: Planning Analytics
Version: 10.1
Excel Version: Office 365

Action button conditional navigation

Post 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.
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Action button conditional navigation

Post 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.
Declan Rodger
User avatar
orlando
Community Contributor
Posts: 167
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365

Re: Action button conditional navigation

Post 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
karlblackler
Posts: 1
Joined: Wed Sep 08, 2010 3:51 am
OLAP Product: IBM Cognos TM1
Version: 11.2.x
Excel Version: 2016

Re: Action button conditional navigation

Post 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
Post Reply