Show TOC

Authorizations for BW and SAP HANA (Mixed Scenarios)Locate this document in the navigation structure

In scenarios where data modeled in the BW system is merged with data modeled in SAP HANA with SAP HANA tools, the relevant authorizations need to be created in SAP HANA.

In the SAP HANA database, analytic privileges are used to define which users are allowed to view which data records for analysis purposes. Analytic privileges are handled as filters for database queries. Users only see the data for which they have an analytic privilege. In BW, however, authorizations do not work as filters. Here, users can only execute a query if their analysis authorizations completely cover the relevant selection. If this is not the case, an error message is displayed. Analytic privileges are persisted on the BW system and in the SAP HANA database.

If you want to create SAP HANA views from InfoProviders, you have two options - each option requires different authorizations:

  • XML-based analytic privileges are generated/defined when SAP HANA views are created from InfoProviders from SAP HANA. More information: Start of the navigation path  Next navigation step Development Information Next navigation step SAP HANA Developer Guide  Next navigation step Importing BW Objects End of the navigation path
  • SQL-based analytic privileges are generated when SAP HANA views are created from InfoProviders from the BW system. More information: Authorizations for Generating SAP HANA Views

Therefore you cannot use the existing analytic privileges of one method for the other method.