Problems generating Hana analytic privileges based on BW info provider

[Former Member]

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

[desgallagher · Accepted solution]

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

[niteshgupta87]

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