Here is the scenario that I am faced with and thought that I would go to you guys for a confirmation. I have checked the options and tried differnt approaches but I think the answer is no.
I have a websheet with 5 tabs and select a subset that has 5 elements within it. If I try to snapshot the sheet to excel and click the appropriate dimension in the snapshot options it will allow me to export the 5 elements to excel. But it does so in a single excel with 25 (5*5) tabs in the workbook. Is there any option that I can set that will create a different workbook per element. In my scenario 5 workbooks with 5 tabs within the workbook?
Also can someone tell me how this would work in PDF format? I am currently on the 64bit version that cannot export to PDF. This was fixed in a later release, but I have not had time to upgrade our environment. Will it create a page per tab so a 25 page PDF?
TM1Web Snapshot to Excel
- George Regateiro
- MVP
- Posts: 326
- Joined: Fri May 16, 2008 3:35 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2007 SP3
- Location: Tampa FL USA