Application worksheets, macros and websheets
Posted: Fri Oct 20, 2017 11:45 am
Hi All
I wanted to canvas some ideas for a direction of travel, before embarking on some development surrounding reporting from Perspectives based reports and web reports.
It's common to produce a Perspectives excel report, perhaps adding some macros to it and then publishing it to the "Application" folders for users to use. But when those reports are accessed via TM1Web, the macro functionality is lost.
So, very often for TM1Web, we make a "light" or "macro-less" version of a report. My question is based around how that version is then deployed to the end user. Most ADMINs will publish these into the Application folders, but how would you stop access in TM1Web to the "macro'd" reports, particularly when it is not possible to segregate users between TM1Web and perspectives, thus making both reports accessible. Are there alternate places to publish these reports ? Is there a need to have Application folders for web and those for Perspectives ? Is security to the folders the answer ?
Is there a way to keep reports distinct from the users using TM1Web and Perspectives ?
How have others approached this ? Am I looking at this in the wrong way ?
Thoughts gratefully welcome.
Thanks
Ajay
I wanted to canvas some ideas for a direction of travel, before embarking on some development surrounding reporting from Perspectives based reports and web reports.
It's common to produce a Perspectives excel report, perhaps adding some macros to it and then publishing it to the "Application" folders for users to use. But when those reports are accessed via TM1Web, the macro functionality is lost.
So, very often for TM1Web, we make a "light" or "macro-less" version of a report. My question is based around how that version is then deployed to the end user. Most ADMINs will publish these into the Application folders, but how would you stop access in TM1Web to the "macro'd" reports, particularly when it is not possible to segregate users between TM1Web and perspectives, thus making both reports accessible. Are there alternate places to publish these reports ? Is there a need to have Application folders for web and those for Perspectives ? Is security to the folders the answer ?
Is there a way to keep reports distinct from the users using TM1Web and Perspectives ?
How have others approached this ? Am I looking at this in the wrong way ?
Thoughts gratefully welcome.
Thanks
Ajay