HANA Data Preview access missing for BW generated content

[Former Member]

I have a calculation view generated from aninfocubeand when I try to do a data preview using the SYSTEM id I get the above error. I have the following already set up.

_SYS_BIC, _SYS_REPO, _SYS_BI and REPOSITORY_REST with select and execute privilege. I also have the system schema  SAPDEV logged in and granted the schema SAPDEV access as well. Can anyone point me in the right direction as to what is missing?

[lucas_oliveira]

Hello Rahul,

No you don't need to (and honestly you shouldn't, depending on your scenario) give SELECT privileges directly to the schema to the user that will only use the view to access the data.

What you might be missing here is an Analytic Privilege. Strange, since SYSTEM has MODELING role by default and that has an open Analytic Privilege ( _SYS_BI_CP_ALL, kind of like a BI_ALL for Hana information views). Maybe this was changed on your system...

You can troubleshoot missing authorizations by following the documents below:

Runtime Authorization Check of Analytic Privileges - SAP HANA Developer Guide for SAP HANA Studio - ...

Let us know what was the issue later on.

BRs,

Lucas de Oliveira