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
configuration for Planning Analytics For Excel
-
- Posts: 96
- Joined: Mon Jul 29, 2019 5:02 am
- OLAP Product: Planning Analytics
- Version: 2.0.9.x
- Excel Version: Office 365 16
Re: configuration for Planning Analytics For Excel
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
-
- Posts: 4
- Joined: Thu Jul 27, 2023 11:28 am
- OLAP Product: TM1
- Version: 2.0.9.15
- Excel Version: 2016
Re: configuration for Planning Analytics For Excel
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
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