Action button conditional navigation

Post Reply
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 » Mon Jan 14, 2019 12:56 am

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.

Posts: 1605
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

Re: Action button conditional navigation

Post by declanr » Mon Jan 14, 2019 8:10 am

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.

User avatar
Posts: 64
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0
Excel Version: Office 365

Re: Action button conditional navigation

Post by orlando » Mon Jan 14, 2019 9:11 am


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


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 » Mon Jan 21, 2019 12:41 pm

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;
that needs to be set, else it doesn’t do the recalc beforehand.


Post Reply