Page 1 of 1
Convert Excel Reports to Static Reports
Posted: Wed Sep 22, 2010 4:05 am
by PlanningDev
I know that you can use Snapshot to create static data in Excel but is there an easy way to take an excel workbook with TM1 views in it and convert all the tabs to static values?
Re: Convert Excel Reports to Static Reports
Posted: Wed Sep 22, 2010 4:07 am
by Alan Kirk
PlanningDev wrote:I know that you can use Snapshot to create static data in Excel but is there an easy way to take an excel workbook with TM1 views in it and convert all the tabs to static values?
Three easy ways, actually, the choice is yours:
http://forums.olapforums.com/viewtopic.php?f=21&t=2515
(I rather lean towards ZapFormulas, myself... unbiased opinion, of course.)