"MDX statement error: Value 2016.YR.INP 0HIER_NODE for characteristic /CPMB/V9DTYMW unknown" while refreshing input template in BPC NW 10.1

[karan_kothari2]

Hi Experts,

I am refreshing an input template and its giving me below error:

Time Hierarchy is as below:

Further the same template is working properly in PRD server having same time hierarchy rather it is giving error in DEV client.

Please advice!!

Thanks

Karan

[former_member186338]

Your INP members need to have same 3 level hierarchy as normal months. Please search forum I have explained it number of times.

[karan_kothari2]

Hi Vadim,

Thanks for the revert.

I have already gone through your posts:

https://scn.sap.com/thread/3517327

But currently in my scenario, the same thing is working in PRD client with same hierarchy structure. If the reason would be same then it should not work in PRD also.!!

Thanks

Karan

[former_member186338]

Sorry, I have no time to compare your systems... May be sp level is different or something else. Make 3 level and everything will be fine

BPC is creating some hidden hierarchies and it require 3 level.

[Former Member]

Hi Karan,

Below is a thread with same error...

Please refer the notes given.....might be helpful...

Regards,

JP