
This lesson covers a common scenario where a client integrates analysis authorizations but needs a straightforward method for granting users access to all data, such as for testing purposes.
Objective
This lesson covers a common scenario where a client integrates analysis authorizations but needs a straightforward method for granting users access to all data, such as for testing purposes.
When a query is initially executed, the check by the authorization objects S_RS_COMP and S_RS_COMP1 must be successful.
If the InfoProvider on which the query is based contains characteristics flagged as authorization-relevant, the user needs analysis authorizations for the related authorization-relevant data.
For simple analysis authorization requirements, or when a user needs analysis authorizations for all data, for example for test purposes, there is the Special Analysis Authorization: 0BI_ALL.
In the figure shown, we can see the details of the analysis authorization of 0BI_ALL.
Note
Occasionally, the automatic update fails. Then you can perform the update manually. On the Management of Analysis Authorizations screen (transaction code RSECADMIN
), choose Extras → Update Authorization 0BI_ALL.
As shown here, analysis authorizations, and thus also special analysis authorization 0BI_ALL, can be assigned to the users in one the following ways:
As shown in this figure the authorization object S_RS_AUTH can include analysis authorizations in roles. It consists of only one field BIAUTH where previously defined analysis authorizations are to be entered. The generated special analysis authorization 0BI_ALL can also be entered here. The following are the steps to assign an analysis authorization to a role:
In the following three videos, a new reporting user is created and gradually provided with authorizations so that this reporting user can execute a BW query and display data.
The Student11 user has all authorizations in our SAP BW/4HANA system and acts as a user and authorization administrator. It therefore creates new users and roles and assigns authorizations.
In this video, you learn how to grant authorization to connect to SAP BW/4HANA using SAP Analysis for Microsoft Excel to a reporting user.
In this video, you watch a demonstration that shows how to maintain the authorization settings for executing queries.
In this video, you watch a demonstration that shows how to troubleshoot and address the error message shown in video 2.
Log in to track your progress & complete quizzes