Hi All,
I hope someone can shed a light here.
I have a report in TM1Web with about 9 tabs, Is there a way that when a user exports to PDF or excel (snapshot and/or slice) the exported file only contains specific tabs? say only sheet 1, 4, 5 and 6 and therefore the other sheets in the workbook are skipped/excluded.
Also is there a way to completely disable the export options, mainly looking at the slice.
Any help will be really appreciated.
TM1Web - Websheets - Customisation of data export options
-
Wim Gielis
- MVP
- Posts: 3241
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1Web - Websheets - Customisation of data export option
As to the first question, I don't think this is possible.
What happens if you set sheets hidden in Excel, or even 'Very hidden' (through VBA)? I've never experimented with that.
For the second question: I don't think there is a setting to disable the exports (other than hiding toolbars...)
If you search for "Setting the Maximum Number of Sheets to Export from a Cube Viewer" you will find a setting in the Web.config file.
What happens if you set the maximum sheets equal to 0? Just a wild guess...
What happens if you set sheets hidden in Excel, or even 'Very hidden' (through VBA)? I've never experimented with that.
For the second question: I don't think there is a setting to disable the exports (other than hiding toolbars...)
If you search for "Setting the Maximum Number of Sheets to Export from a Cube Viewer" you will find a setting in the Web.config file.
What happens if you set the maximum sheets equal to 0? Just a wild guess...
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
RCO
- Posts: 40
- Joined: Mon Sep 09, 2013 7:16 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1Web - Websheets - Customisation of data export option
Thank you Wim for your kind reply.
I tried setting the sheet as very hidden but it makes no difference to just hiding it..
I have come up with a sheet which is being linked by a second hidden sheet to just populate the data that the business wants to expose to users in this specific report.. I believe management is happy with the output.
As for the second question, I will just leave the export options visible, the business doesn't like the idea of all or nothing so we will just leave it.
Once again thank you for your reply.
I'm more than happy to hear any other ideas from anyone who knows a work around for enabling just 1 or 2 export options without hiding the tool bar
I tried setting the sheet as very hidden but it makes no difference to just hiding it..
I have come up with a sheet which is being linked by a second hidden sheet to just populate the data that the business wants to expose to users in this specific report.. I believe management is happy with the output.
As for the second question, I will just leave the export options visible, the business doesn't like the idea of all or nothing so we will just leave it.
Once again thank you for your reply.
I'm more than happy to hear any other ideas from anyone who knows a work around for enabling just 1 or 2 export options without hiding the tool bar