TM1 Forum

Hello
I have two websheets in PAX (Planning Analytics For Excel), they contain dynamic reports with almost the same number of rows but which point to two different cubes, one opens normally and the other which bugs as soon as I put myself on totals for the dimensions (it doesn't open)
I heard about a PAX configuration file (eg for memory or....), but I have no idea about this file.
Do you have an idea?

Thanks in advance

Nasrine wrote: ↑Wed Sep 27, 2023 3:51 pm the other which bugs as soon as I put myself on totals for the dimensions

You need to be much clearer and detailed if you are seeking help. eg:

1) Does the dynamic report return the expected data when you REBUILD with the workbook open
2) Do you receive any error messages
3) How have you constructed totals on the dimension
4) Are you opening a saved file in Excel or via web?
5) How many rows are you expecting will be returned?
6) So on

Hello
1)No, as soon as we look at the total Excel bug, no line is displayed
2)No error is returned
3)Total is the consolidation of the elements of the dimension, the mdx in the rows is: {Tm1FilterByLevel({Descendants([Dimension].[TOTAL_Dimension])}, 0)}
4)In Excel, no problem in TM1 web
5)Around 2500 rows
6) Thanks