Removing "Export / Slice to Excel" option from Web

[garry cook]

Been looking into removing this option for exactly the reasons found here.

My hopes aren't high but thought it would be worth a check to see if anyone has managed to find a workaround to bypass the classic "It's on the Roadmap!" response? Client is 10.2.2.

TIA

[pandinus]

As far as I know the only option you have is to manually adjust the JavaScript files that render the web. By removing the options from the necessary arrays, the export options will no longer show.
I once managed to do so in a test-environment, but decided to not roll this forward to production.

[gtonkin]

Hi Garry,
I have not been able to remove the options but have been able to render them less than useful by doing the following in the TM1Web_Config.xml

Code: Select all

<!-- MaximumSheetsForExport: Maximum number of sheets allowed to Export -->
 <add key="MaximumSheetsForExport" value="0" />

Cannot export to PDF either but if you have ever tried, you will not be losing much.

Users can still select the options but the OK is blanked out and they cannot submit. Not elegant but better than removing the cube view controls through }ClientProperties.