Jul 01, 2019 at 01:14 PM

Hierarchy based analytic privilege in hana 2.0 SP02 on premise

256 Views Last edit Jul 02, 2019 at 12:27 PM 2 rev

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