Attribute view issue

[Former Member]

Hi All,

I created a attribute view with parent child hierarchy within it. I checked the data preview i can able to see the data.

But when i checked the content of the hierarchy attribute in the column view getting a error message "root node id mismatch".

PFB  screenshot for your reference:

Attribute view screenshot.

PAR_CHIL is parent child hierrachy. When i checked the content of the hierarchy attribute (0/TT_P_HI/hier/PAR_CHIL im getting the below error message.

But when i check it for level hierarchy attribute i can able to check the content. The issue is only parent child hierarchy attribute not with the level hierarchy attribute.

Am i missing anything when creating parent child hierarchy?

Please guide me in this.

TIA

[Former Member]

Hi Anooj,

The reason i checked in column view is that i cannot view the analytic view (with parent child hierarchy) in the excel.

Im getting the below error message,

"Excel was unable to get necessary information about this cube. This cube might have reorganised or changed on the server.

Contact the OLAP cube administrator and, if necessary, set up a new datasource to connect the cube."

But when im using with level hierarchy i can view the data in excel.

Thats how i checked the hierarchy column view.

TIA