Skip to Content
0
Apr 18, 2014 at 04:19 AM

Analytic Privilege Not Working

1326 Views

Hi All,

I am trying to create a simple analytic privilege following the documents like

http://scn.sap.com/community/hana-in-memory/blog/2012/05/30/user-management-analytic-privileges

http://help.sap.com/openSAP/HANA1/openSAP_HANA1_Week_02_Unit_09_Analytic_Privileges_Presentation.pdf

I have created the AP on top of a calculation view and assigned following authorization/privileges to the end user.

Granted Roles

  • Public

SQL Privilege

  • SYS_BI – Execute – With EXECUTE, SELECT, INSERT and UPDATE

(not grantable to others)

  • _SYS_BIC – Execute – With EXECUTE and SELECT (not grantable to others)
  • REPOSITORY_REST (SYS) – With EXECUTE (not grantable to others)

Analytic Privilege

Analytic privilege that I created

System Privilege

  • NONE

Package Privilege

  • NAME OF PACKAGE - REPO.READ (not grantable to others)

The problem is that on doing data preview of calculation view, I am getting "User is not authorized" error.

However if I assign _SYS_BI_CP_ALL AP, then user is able to view all the data of calculation view.

What am I doing wrong here? Why without _SYS_BI_CP_ALL, I am getting authorization error?

Regards,

Raja