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.
Action button conditional navigation
-
- MVP
- Posts: 1817
- 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
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.
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
- 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
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
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
-
- 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
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
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