Skip to Content

Problems generating Hana analytic privileges based on BW info provider

Hi Experts

We generate Hana views based on BW Info Providers. We follow the guide “SAP First Guidance – SAP NetWeaver BW 7.40 on HANA View Generation”. . The views appear perfectly in Hana Studio but we are not able to generate the authorizations in Hana.

On the BW side we have a authorizations relevant info object in the DSO that generate the View in Hana. The info object is linked to an authorization object that again is linked to a role. The role is the assigned to a user. We have synced all our users from BW to Hana using the standard concept (same username in BW and Hana).

When the view is generated we can see that view in Hana and we can see that a role is also create in Hana. But there are no analytical privilege created and there are no entries added in the table RS2HANA_AUTH_STR. The user also do not get the role assigned to him.

Are there any other steps that need to be done to be able to generate the authorizations in Hana based on BW authorizations?

We use BW 7.4 and the generate function (not the import function into Hana).

Kind regards

Erik

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 12, 2015 at 05:51 PM

    Hi Eric,

    Please check if the SAP notes https://css.wdf.sap.corp/sap/support/notes/2034815 and https://css.wdf.sap.corp/sap/support/notes/2031522 are applied in your system. The notes should at least help you analyse why the authorizations are missing.

    Kind Regards,

    Des


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 09, 2015 at 12:25 PM

    Hi Erik,

    Please check if below characteristics are included in the analysis authorization assigned to the user:

    0TCAIPROV = Info provider id

    0TCAACTVT = 03

    0TCAVALID = *

    0TCAKYFNM = *

    <authorization relevant characteristic of your info provider> = Required value.

    If you are assigning these authorizations now, run RS2HANA_CHECK tcode for this user. This should generate analytic privilege and user should get the role in HANA.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded