Skip to Content
0
Jan 17 at 09:49 AM

Define hierarchial privilege via Analytic Privileges (.hdbanalyticprivilege) in Hana Cloud

103 Views

Hi Collegues,

I am trying to define attribute restrictions using hierarchy node column.

For that purpuse I followed sap documantation: link

I define 2 tables: fact table + dimentional data

image.png

image.png

Then I created star join calculation view mdel to join these two tables. There I enabled SQL access to the shared hierarchies in star join calculation views as was mentioned in documentation:

image.png

But when I tried to create Analytic Privileges (.hdbanalyticprivilege) file the possibility to add hierarchy restriction was locked

screenshot-2023-01-17-at-124053.png

How to unlock the add button? maybe someone has already faced this issue.

Thanks,

Volha

Attachments

image.png (43.8 kB)
image.png (27.6 kB)
image.png (142.4 kB)