TM1Web Snapshot to Excel

Post Reply
User avatar
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

TM1Web Snapshot to Excel

Post by George Regateiro »

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?
Post Reply