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

[karan_kothari2]

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

[former_member186338]

Upgrade recommended! For both!

[karan_kothari2]

Hi Vadim,

Can you please guide me about the recommended versions? i.e. which are the recommended versions for both in above scenario?

Thanks,

Karan

[former_member186338]

Simply use latest!

[former_member186338]

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

[karan_kothari2]

Hi Vadim,

Thanks for the prompt revert.

Please find attached screen shot regarding versions.

Thanks,

Karan