HANA Analytical Privilege in Parent-Child Hierarchy gets error

[Former Member]

Hi!

We are using SAP HANA sps12. We have a parent-child hierarchy in Calculation View. In the hiearchy, we have more than one parent.

Based on requirement, we have defined classical analytical privilege on a number of child node values.

When we assigned to the user with the defined analytical privilege, data with selected child node values did not appear. Instead, we get the error of 'insufficient privilege: [2950] user is not authorized.

Is this functionality available in HANA sps12? I did some research and in the following link

https://blogs.sap.com/2015/07/09/new-hierarchy-sql-enablement-with-calculation-views-in-sap-hana-10-...

it is mentioned that For parent-child hierarchies, compound hierarchies are not supported, i.e. the parent child hierarchies must only have a single attribute as parent and child.

Your input is much appreciated.

thanks

-eric