Skip to Content

Refresh Report Error: MDX statement error:"Dimension [/CPMB/NZDU7X8 PARENTH1] unknown"

Hi Experts,

While refreshing a report in excel, it is giving an error as mentioned in the given below screen shot:

We have checked hierarchy in the back end (RSA1) for the same dimension and observed that there are two hierarchies have been generated i.e. one is with version "A" and another one with version "M" (Screen shot attached) and the same seems to be the reason for the error in the reporting.

Further we have only single hierarchy maintained in the BPC then why it generating the same twice with different version automatically.!!

How we can remove this another hierarchy with version "M" as the same is not needed and generating automatically.!

Needs permanent solution on the same.

Thanks,

Karan

error.jpg (62.2 kB)
error.jpg (60.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 11, 2016 at 09:21 AM

    Please provide the detailed info about your BPC and BW versions and SP!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 11, 2016 at 11:12 AM

    Upgrade recommended! For both!

    Add comment
    10|10000 characters needed characters exceeded