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),
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?