TM1 Forum

Hi, All

I am getting following error while refreshing sheet. Except this report, I am able to refresh all other reports on the same workbook but on different worksheet.
Error:

IBM PAX Error.PNG (6.48 KiB) Viewed 1012 times

Anyone experienced this before? How could I resolve it?

Thank You for your Input.
Dharav

All,

Work-around/Solution:
I moved this report to different book and copied back to existing book with different name.

** I am still interested to know how indexing plays. What was error about?

Thank You
Dharav

Hi,

this can appear when you have a mismatch in quick report and cube structures.
Possible reasons:

1. You have several dimensions in rows/columns, and their order is broken (eg you have accounts and months in rows (in this order), but the labels aer in different order (September, Revenue))
2. Sandbox does not exist
3. Number of filter dimensions <> number of dimensions in cube - # row dims - # column dims

Check the corresponding named ranges carefully