Navigating Between Websheets using Sheetnames
Posted: Thu Mar 13, 2014 8:45 am
Hello All,
I Have two websheets, one with Actual an Forecast data on a high level, with 4 different tabs in it which present the data all in a different way. I have one Websheet with the actual data on detailed level.
It is possible to 'drill' to the detailed data with a Tm1 action button, in the action button the following takes place;
I also map some items in the advanced options tab, that all works fine
Now I want to map the actual sheet where I'm in to the websheet(workbook) I'm opening, so when I move back from the detailed websheet (workbook) to the other one I can use this value to jump back to the tab I was in before.
I have found one possibility to do this, just store the sheet name somewhere in the sheet and refer to that cell in the advanced options of the action button.
But I prefer to get the sheetname with a formula, in Excel I can extract it from this formula CELL("filename";A1), this does not work in Tm1web. Anyone another idea?
One option could also be not using the option 'Replace Current Workbook', but that one I need because else the detailed sheet is not build up the right way when I go there a second time with another selection, I then need to hit the rebuild button in tm1 web another time to get the right view (also selected rebuild sheet, see the screenshoot).
Someone any thoughts on this one?
Thnx!
Sander
Excel Version 2013
Tm1 10.2 FP1
I Have two websheets, one with Actual an Forecast data on a high level, with 4 different tabs in it which present the data all in a different way. I have one Websheet with the actual data on detailed level.
It is possible to 'drill' to the detailed data with a Tm1 action button, in the action button the following takes place;
- ScreenHunter_172 Mar. 13 09.25.jpg (44.53 KiB) Viewed 2548 times
Now I want to map the actual sheet where I'm in to the websheet(workbook) I'm opening, so when I move back from the detailed websheet (workbook) to the other one I can use this value to jump back to the tab I was in before.
I have found one possibility to do this, just store the sheet name somewhere in the sheet and refer to that cell in the advanced options of the action button.
But I prefer to get the sheetname with a formula, in Excel I can extract it from this formula CELL("filename";A1), this does not work in Tm1web. Anyone another idea?
One option could also be not using the option 'Replace Current Workbook', but that one I need because else the detailed sheet is not build up the right way when I go there a second time with another selection, I then need to hit the rebuild button in tm1 web another time to get the right view (also selected rebuild sheet, see the screenshoot).
Someone any thoughts on this one?
Thnx!
Sander
Excel Version 2013
Tm1 10.2 FP1