Solved:Snapshot to Excel - Websheet - Number of Sheets to Export Exceeds Max

[gtonkin]

I know this should be as simple as updating the tm1web_config.xml with something other than zero for

Code: Select all

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

My issue is that I can export cube views but not from web sheets. I have never needed to snapshot/slice a websheet but a set of users is asking for it and it appear that you cannot do this. As soon as you tick one of the sheets to export you get the number of sheets exceeded message.
Exporting from a cube view is fine. Setting the MaximumSheetsForExport to zero disallows both web sheets and cube views.
I have not made any changes to }ClientSettings or CapabilityAssignments
I have also tried adding ExcelWebPublishEnabled=T to my tm1s.cfg - did not help. Seem too think this parameter is now legacy with the re-write of TM1 Web anyway.

I get the same results on 10.2.2 and 10.2.2 FP4, Windows 2008R2 server, IE and Firefox tested. Have also restarted the TM1 instance and the Application server after making changes to be sure.

Would appreciate if someone could point me in the right direction if there is a setting I have missed or alternatively if I am trying to do something that is not actually possible.

Thanks in advance.

[gtonkin]

Update:
The workbook has 4 tabs, 1 information sheet with a reference to the Scenario dimension, the other 3 have active forms with MDX to generate a list of Employees.
If I tick the 1st dimension appearing on the information tab, I can export. If I tick dimensions on the other sheets, I get the message immediately.
My MDX has 1807 elements being returned times 4 sheets = 7228 Sheets to be exported - my MaximumSheetsForExport was set way too low. After increasing this to 10000, I could do the export but this would be pointless.

I my particular case, what the users would need to do is rebuild each sheet's active forms then export and only tick the first sheet. This will produce 1 workbook with the results as viewed after refreshing.

I guess I was having a blonde moment mistaking the tick boxes for exporting sheets rather than referencing the dimension on that sheet - 4 sheets, 4 tick boxes.

Thanks to all who read the initial post and pondered the problem - apologies for the false alarm - PICNIC/PEBCAC.