Hierarchy based analytic privilege in hana 2.0 SP02 on premise

[former_member250641]

Hi Team ,

I have requirement there we have company code ,

Profit center ,Segments , all are level based hireachy calculation , Now I have to restrict the data based on level .

Example : suppose user A belongs to Level 3 company code so the user can see the level 1 and level 2 data and level 3 . And the level hireachy apply all the calculation view we have .

And we are following the xs classic concept development.

Please help me on that .

2) We Created the calculation view and properties we make apply privilege as SQL analytic Privilege and engine Make as SQL engine but after activation of the view the owner user / created user can't see the data preview its showing authorization issue . But if we make classical analytical privilege don't have that issue Now we need SQL based analytic so what should we do ?

Thanks ,

Sumit

[former_member612251]

Hi Sumit,

I find it hard to follow your above explanation but from what I can gather, you are seeing authorization errors for the SQL based AP but it works with an XML analytical privilege (classical)?

First thing that comes to mind is that you haven't granted this SQL privilege to the user for the SQL AP and for the XML AP, your user may have the role _SYS_BI_CP_ALL, so all classical AP's would work for a user.

An old note I wrote a while back comes to mind here:

https://launchpad.support.sap.com/#/notes/2540498

Cheers,