Skip to Content
0
Jun 12, 2017 at 08:58 AM

External SAP HANA view privileges

4905 Views

Hi all,

In bw I have created a external view of a InfoCube.

On the HANA side in the "system-local > bw > bw2hana" package a calculation view was created. A security role and analytic privilege were also created.

The role and the analytic privileges are assigned to my user. The role "_SYS_BI_CP_ALL" is also assigned to my user.

I also created a object privilege on

"SYS_BIC" (execute and select),

"REPOSITORY_REST (execute)

and a REPO.READ package privilege.

When I try to preview the data of this calculation view I get the error:

"Could not obtain all relevant analytical privileges for user xxxx accessing view ._SYS_BIC.system-local.bw.bw2hana/W0xx_xxxx due to exception: Invalid SQL AP definition"

What privilege am I missing?

Thank you