Quick Report - Refresh Sheet throws error

Post Reply
dharav9
Posts: 72
Joined: Wed Aug 15, 2018 3:18 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

Quick Report - Refresh Sheet throws error

Post by dharav9 »

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
IBM PAX Error.PNG (6.48 KiB) Viewed 561 times
Anyone experienced this before? How could I resolve it?

Thank You for your Input.
Dharav
dharav9
Posts: 72
Joined: Wed Aug 15, 2018 3:18 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

Re: Quick Report - Refresh Sheet throws error

Post by dharav9 »

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
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Quick Report - Refresh Sheet throws error

Post by Elessar »

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
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
Post Reply