Skip to Content
0

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

Nov 11, 2016 at 09:18 AM

175

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Nov 11, 2016 at 09:21 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

Thanks for the prompt revert.

Please find attached screen shot regarding versions.

Thanks,

Karan

version.jpg (16.9 kB)
0
Vadim Kalinin Nov 11, 2016 at 11:12 AM
0

Upgrade recommended! For both!

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

Simply use latest!

0