To be able to access SAP HANA views that have been generated from the BW system, you need certain authorizations in the SAP HANA system and in the BW system.
Transaction RS2HANA_CHECK allows you to check all prerequisites for successful replication of BW authorizations to SAP HANA.
To be able to access SAP HANA views that have been generated from the BW system, you need the following authorizations:
These include the following characteristics:
More information: Prerequisites for the Management of Analysis Authorizations
The other authorizations that are needed are generated from the BW system and assigned to the user via roles. An object authorization SELECT is created here for a generated view, and SAP HANA analysis authorizations for the BW analysis authorizations. The roles that are generated always have the following structure for InfoProviders (also for InfoObjects as InfoProviders): <package name> / <SID> _ <view name>_REPORTING. Roles have the following structure for InfoObjects with master data: <package name> / <SID> _ <view name>. The package name is always bw2hana.
If the generated view is called 0BWVC_C03, the generated role will be called bw2hana / SAPKIW _ 0BWVC_C03 _ 2.
You can define in Customizing that the SAP HANA authorizations are assigned to the user directly instead of via roles. To do this, go to Customizing and choose .
BW authorizations cannot be converted 1:1 to SAP HANA. The following restrictions apply to using BW authorizations as SAP HANA authorizations and are not supported:
Hierarchies are converted into a flat list, and an additional technical column (which is invisible) is added to the SAP HANA view.
If you need to filter for the initial value of a characteristic in the BW analysis authorization object, it may not be possible to correctly evaluate this value, which results in a smaller result.
If changes are made to the authorizations in the BW system, the SAP HANA analysis authorizations are not automatically adjusted. You should therefore schedule a regular process chain with process type Replicate Authorizations of BW Users to SAP HANA.