Open sheet 2 worksheet from TM1 web

[daya007]

Hi

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>

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