BW modeling in HANA SPS09+

[former_member216578]

Hello.

We have a scenario, where HANA Modeling artifacts generated from BW (Attribute Views for InfoObjects, Calculated Views for DSO) are consumed directly in database (via SBOP BI Universe).

One of the new features of HANA SPS09 is the ability to create two types of Analytic privileges: SQL Analytic privilege and Analytic privilege. For analytic privilege there was an "out-of-box" privilege _SYS_BI_CP_ALL, that allows you to read any information view (Attribute/Analytic/Calculation view) marked as Apply privilege = 'Analytic privilege'.

The question is: is there any "default" SQL Analytic Privilege, that allows access to all data in any information view (like _SYS_BI_CP_ALL for XML Analytic privilege)? Because newly generated artifacts have Apply privilege = 'SQL Analytic privilege', so we had to manually generate and grant corresponding SQL Analytic privileges.

Regards,

Andrey.

[antonio_nunes1]

Hi

I think you can get that functionality with some code. In the following URL there are some examples on how to use the statement "CREATE STRUCTURED PRIVILEGE" to create SQL Analytic Privilege using Hana workbench:

https://help.sap.com/saphelp_hanaplatform/helpdata/en/63/efa79c963d4243ad2a894e2b5bd10c/content.htm

Hope it helps,

Best regards