Skip to Content
avatar image
Former Member

HANA Data Preview access missing for BW generated content

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?

saphanaaccess.png (104.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 18, 2015 at 12:24 AM

    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:

    Authorization Dependency Viewer

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

    Let us know what was the issue later on.

    BRs,

    Lucas de Oliveira

    Add comment
    10|10000 characters needed characters exceeded