SAP SQL Analytical privileges issue

[vara_yarramsetty]

Hi All

This question is related to Analytical privileges.

I am user1 having HANA MODELING role and created calculation view CV_TEST

I changed  Apply privileges: value to SQL Analytic Privileges in the properties of calculation view and activated.

When I am previewing the data I am getting the following error message

"Error executing the query Error: SAP DBTech JDBC:[258]:insufficient privilege"

I am using SAP HANA SP11.

I should be able to access all the data since I have HANA modeling role correct??

Is there any permissions I am missing?

If I assign "Classical Analytic Privileges" then I can see all the data and no error message.

Thanks,

Vara

[SergioG_TX]

Vara,

there is more than just "apply analytical privileges" to be able to use AP.

you will need to define an "analytic privilege" object. you will need to configure what is the view(s) on your AP - APs are only assigned to views and not to tables. you will need to specify the column and condition for your analytic privilege.

once a calc view is created and an AP is also created, then you need to assign the AP to a user.

here is a simple blog

good luck!

[vara_yarramsetty]

Hi Sergio: Yes. That is correct. it is working fine when I assigned to AP to regular user and data is restricted.

My question is if you are a developer and having HANA modeling role and you should be able to see all the data.

Steps for replication:-

1) Open the calculation view

2) Click on Semantics of this view and go to properties and change the Apply Privileges to "SQL Analytic Privileges"

3) Save and Activate.

4) Click on Preview.

5) You will be getting the error message "Error executing the query Error: SAP DBTech JDBC:[258]:insufficient Privileges".

Thanks,

Vara

[SergioG_TX]

Vara,

even if you are a hana modeler, as long as the AP is not assign you wont be able to see the data. again, because that is the purpose of the AP.. think about sensitive data.. you may not want all developers to be able to see it... that's just the principle behind APs. hope this is a good explanation.

[vara_yarramsetty]

Hi Sergio: In that case why it is working for Classical Analytic Privileges?

Try same above steps but in Step No.2 assign Classical Analytic Privileges in the properties of calculation view.

Save and active and I am able to preview the data and no issues.

Is there any change in the concept for Sql Analytical privileges?

Thanks,

Vara