Convert Excel Reports to Static Reports
-
PlanningDev
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Convert Excel Reports to Static Reports
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?
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Convert Excel Reports to Static Reports
Three easy ways, actually, the choice is yours: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?
http://forums.olapforums.com/viewtopic.php?f=21&t=2515
(I rather lean towards ZapFormulas, myself... unbiased opinion, of course.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.