Skip to Content
0

HANA Analytical Privilege in Parent-Child Hierarchy gets error

Dec 27, 2016 at 12:18 AM

142

avatar image

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-sps-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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers