HANA views generation on BW Infocubes

[Former Member]

Hello

Im trying to generate HANA Views on BW infocubes using 'Generate HANA Views' option in the infocubes. I was able to generate the view on infocube and I could preview the data in Studio. When I;m trying to access the HANA view in reporting tools, Authorization issue has been raised.

I went ahead and checked consistency of the HANA view using RS2HANA_CHECK tcode. I'm getting below error messages.

error 1:

--------------

InfoProvider &&&&: Filter string does not exist

    Message no. RS2HANA_CHECK014

Diagnosis

    No entry exists in table RS2HANA_AUTH_STR for the mentioned InfoProvider

    and BW user. When accessing the generated SAP HANA View the database

    user is not authorized.

Procedure

    Make sure no other errors are displayed, otherwise correct the errors.

    Then trigger the SAP HANA Model Authorization Replication again by

    either activating the mentioned InfoProvider or running report

    RS2HANA_AUTH_RUN.

error 2:

------------

User SAP<SID>: Select on View failed

     Message no. RS2HANA_CHECK055

Diagnosis

     Running an example SELECT statement on the specified SAP HANA View

     failed for the mentioned user and specified database connection.

     If check "Existence and Assignment of SAP HANA Privilege(s)" is enabled,

     warning message RS2HANA_CHECK077 "Privilege on OLAP view is missing"

     should be displayed, too. If so, follow the instructions mentioned in

     the long text of message RS2HANA_CHECK077.

Procedure

     Make sure all prerequisites are met in order for the BW user to be able

     to access the generated SAP HANA View. In addition make sure no errors

    are displayed for the mentioned user, otherwise correct the issues and

    try again.

    Also make sure that you selected to check "Existence and Assigment of

   SAP HANA Privilege(s)" and look for warning message RS2HANA_CHECK077

  "Privilege on OLAP view is missing".

--------------

I checked table RS2HANA_AUTH_RUN and I could see a record for my user id generated.

We didnt get any RS2HANA_CHECK077 "Privilege on OLAP view is missing" message.

Any help is appreciated.

Thanks,

John.

[anindya_bose]

Does this InfoCube contain any Authorization related InfoObject ?

Did you already check this note ?  http://service.sap.com/sap/support/notes/2031522

What is your reporting tool ?

Cheers

Anindya

[Former Member]

Yes I have auth relevant infoobjects in my cube. I can see the data generated for these auth relevant infoobjects in table RS2HANA_AUTH_RUN for my user id. I did check the OSS note and I'm getting the above said error message from RS2HANA_CHECK tcode. I'm using BEX Analyzer and Analysis for Office tools.

[anindya_bose]

Just checking the basics..

Did you provide BW Schema access to _SYS_REPO ?

If not, please run this SQL and test again:

GRANT SELECT ON SCHEMA <BW_SCHEMA> TO _SYS_REPO WITH GRANT OPTION

Anindya

[Former Member]

Schema access to _SYS_REPO is in place.

in RS2HANA_SCHEMA tcode, if I include SAP<SID> user ID (Include SAP<SID> user) too in the Concerned Objects list, I get above said errors. If I exlude SAP<SID> and run it only for my own user (BW User section) id, everything is fine,

[Former Member]

Any further help is appreciated

[Former Member]

Has anyone experienced the same issues?

[Former Member]

Any inputs appreciated.

[Former Member]

Any help?