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 ?