Assigning Analysis Authorization 0BI_ALL for All Data

Objective

After completing this lesson, you will be able to assign analysis authorization 0BI_ALL for all data

Business Example

Person holding tablet thinking about the customer need to integrate analysis authorizations and the need to granting users access to all data particularly for testing purposes.

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.

Analysis Authorization for All Data

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.

Screenshot of the configuration of the authorization 0BI_ALL is expanded into 2 seperate screenshots 1. A screenshof of the characteristic 0CO_AREA which is expanded with authorization-relevant setting highlighted. 2.A screenshot of the navigation attribute P_CATEG is expanded with authorization-relevant setting highlighted.

In the figure shown, we can see the details of the analysis authorization of 0BI_ALL.

  • The analysis authorization 0BI_ALL consists of all characteristics and navigation attributes flagged as authorization relevant and authorized for all values (*), grants access to all authorization-relevant data.
  • 0BI_ALL is a generated analysis authorization that cannot be edited manually. It is automatically updated whenever a characteristic or navigation attribute is set to authorization relevant.

Note

Occasionally, the automatic update fails. Then you can perform the update manually. On the Management of Analysis Authorizations screen (transaction code RSECADMIN), choose ExtrasUpdate Authorization 0BI_ALL.

A screenshot of the 0BI_ALL Display with a process diagram expanded to show 2 ways in which the 0BI_ALL can be assigned to users

As shown here, analysis authorizations, and thus also special analysis authorization 0BI_ALL, can be assigned to the users in one the following ways:

  1. Directly with the user assignment in transaction RSECADMIN
  2. Recommended Method: Indirectly by using the authorization object, S_RS_AUTH and assigning it to a profile and then the profile to a role.

Analysis Authorization Assignment by Role

Screenshots showing the authorization object S_RS_AUTH and an example of its use in a role

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:

  1. Use the transaction PFCG (Role Maintenance), create a new role or enhance an existing one, and add the authorization object S_RS_AUTH into the profile of the role.
  2. In the field BIAUTH of this newly created authorization object, you can use the input help button to select the relevant previously defined or generated analysis authorizations.
  3. The role must be assigned to users using the PFCG transaction (Role Maintenance) on the User tab or the SU01 transaction (User Maintenance) on the Roles tab.

Creating a Basic Role for a Reporting User

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.

1. Granting Authorization to Connect to SAP BW/4HANA 

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.

2. Maintaining the Authorization Settings for Executing Queries

In this video, you watch a demonstration that shows how to maintain the authorization settings for executing queries.

3. Addressing and Troubleshooting Authorization Settings

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