Authorizations for BW and SAP HANA (Mixed Scenarios)

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:  http://help.sap.com/hana_appliance   Development Information  SAP HANA Developer Guide   Importing BW Objects 

• 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.