Open sheet 2 worksheet from TM1 web
Posted: Thu Dec 16, 2010 4:21 pm
Hi
Currently for opening a tm1 web worksheet in report studio am using an iframe script. Please follow below code.
But in one of my worksheets i have 2 sub-sheets. I cannot ask user to navigate sheet 1 and sheet 2 from the bottom of tm1web. We have to assign 2 scripts to open sheet1 and sheet 2 side by side in report studio.
Is there a way to modify above script to open a particular sheet of the worksheet application?
Note: I have tried to upload keeping sheet 1 upfront as one application and sheet 2 as another application. but this will not serve the purpose. There are values which are carrying over from sheet 1 to sheet 2. So there should be one work sheet app but to open two different sub-sheets.
Your help is greatly appreciated.
THanks
Daya
Currently for opening a tm1 web worksheet in report studio am using an iframe script. Please follow below code.
Code: Select all
<iframe
src="http://tm1lab.us.hsbc/TM1Web/TM1WebMain.aspx?AdminHost=tm1lab.us.hsbc&TM1Server=narm_risk_dashboard&action=OpenObject&type=Websheet&value=Applications/CF_Commentary/H60Rate" width="100%" height = "100%" scrolling=no >
</iframe>Is there a way to modify above script to open a particular sheet of the worksheet application?
Note: I have tried to upload keeping sheet 1 upfront as one application and sheet 2 as another application. but this will not serve the purpose. There are values which are carrying over from sheet 1 to sheet 2. So there should be one work sheet app but to open two different sub-sheets.
Your help is greatly appreciated.
THanks
Daya