Page 1 of 1
Action Button - Worksheet Tab Advance Option
Posted: Tue Apr 20, 2010 2:17 am
by appleglaze28
Has anybody ever used the Advance Option in Action Button within the Worksheet tab. I'm just curious how it works and how did any of you guys used this feature. Since I was looking around if there was a way to create a menu that allows the action button to open either a worksheet or a cube without using the TM1 Navigation Tree for TM1 Web.
Re: Action Button - Worksheet Tab Advance Option
Posted: Tue Apr 20, 2010 2:27 am
by Kyro
I've used it to make the selections (SUBNM's) work when the "Match Title Elements" Option stops working. Its like forcing TM1Web to overwrite a cell (within the destination worksheet) with a cell from the source sheet.
I dont think this effects the type of object thats opened.
You could perhaps use the TM1Web API in junction with an Excel =HYPERLINK() function to open a different object based on the content of a worksheet.
Code: Select all
=HYPERLINK(
IF(A1="Cube",
"http://mywebserver/TM1Web/TM1WebMain.aspx?action=OpenObject&type=Cubeviewer&value=SalesCube",
"http://mywebserver/TM1Web/TM1WebMain.aspx?action=OpenObject&type=Websheet&value=Applications/My Reports/Report_2005.
xls")
,"My Dynamic Links Name")
But this will open in a new window unless you muck with the TM1Web Code.