How To Fix RS2HANA_CHECK110 - BW analysis authorizations not maintained

SAP Error Message - Details

• Message type: E = Error

• Message class: RS2HANA_CHECK - RS2HANA Check Report

• Message number: 110

• Message text: BW analysis authorizations not maintained

What causes this issue?

No proper authorizations are maintained for BW user &V1& and InfoObject
&V2&. You need to maintain a specific type of authorizations in BW,
based on the BW object type and the generated external SAP HANA view:
<ZH>External SAP HANA View for Reporting</>: Applies to all types of BW
InfoProviders (including InfoObjects marked as InfoProviders). In order
to correctly replicate authorizations from BW to SAP HANA, you have to
maintain proper authorizations using BW analysis authorizations. For
more information, refer to http://help.sap.com/saphelp_nw74/helpdata/en/
4c/65fcd82f841f3ce10000000a42189c/content.htm?frameset=/en/55/46eb411a7f
6324e10000000a
1550b0/frameset.htm
Here you can find general information on how to correctly maintain
authorizations in SAP BW in the SAP HANA model generation context: http:
//help.sap.com/saphelp_nw74/helpdata/en/a0/f2b32ffcaa40deb60ba4515bbb559
e/content.htm

System Response

No authorizations can be replicated from SAP BW to SAP HANA for BW user
&V1& and InfoObject &V2& as there are no authorizations that can be used
for replication.

How to fix this error?

Make sure you have set up authorizations in BW based on the information
above and on the SAP help websites mentioned above.

Procedure for System Administrators

You can check whether proper authorizations have been set up by running
the following function modules. If these modules do not return an error,
you have set up proper authorizations that can be used for replication
from SAP BW to SAP HANA. However there might be other restrictions (like
all authorization-relevant characteristics have to be contained in a BW
analysis authorization object), which have not been adhered to, but the
function module does not return an error. These issues can be detected
by running transaction RS2HANA_CHECK.
<ZH>External SAP HANA View for Reporting</>: Run function module
RSEC_GET_AUTHS_FILTERED. Enter the InfoObject as a space character,
enter the InfoProvider name and set I_CLEAR to X. Make sure to run
function module RSEC_SET_USERNAME prior to running function module
RSEC_GET_AUTHS_FILTERED, in order to set the correct BW user, for which
you want the authorizations to be retrieved.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RS2HANA_CHECK110 - BW analysis authorizations not maintained ?

  The SAP error message RS2HANA_CHECK110 indicates that BW (Business Warehouse) analysis authorizations are not maintained for a specific user or role when trying to access data in SAP BW on HANA. This error typically arises when the necessary authorizations for accessing BW data are not properly set up, which can prevent users from executing queries or reports.
  Cause:
  
  Missing Authorizations: The user or role does not have the required BW analysis authorizations assigned.
  Incorrect Role Assignment: The roles assigned to the user may not include the necessary authorizations for the BW objects they are trying to access.
  Authorization Objects Not Defined: The relevant authorization objects for BW analysis might not be defined or activated in the system.
  Data Source Issues: The data source or InfoProvider being accessed may not have the correct authorizations set up.
  
  Solution:
  
  
  Check User Authorizations:
  
  Go to transaction SU01 (User Maintenance) and check the authorizations assigned to the user.
  Ensure that the user has the necessary roles that include BW analysis authorizations.
  
  
  
  Maintain BW Analysis Authorizations:
  
  Use transaction RSECADMIN to maintain and check the BW analysis authorizations.
  Ensure that the relevant authorization objects (like S_BI_WA) are properly configured for the user or role.
  
  
  
  Role Assignment:
  
  If the user is missing roles, assign the appropriate roles that include the necessary authorizations for accessing BW data.
  Use transaction PFCG (Role Maintenance) to create or modify roles and include the required authorizations.
  
  
  
  Check Authorization Objects:
  
  Verify that the relevant authorization objects are defined and activated in the system.
  Ensure that the InfoProviders and queries are linked to the correct authorization objects.
  
  
  
  Testing:
  
  After making changes, test the access again to ensure that the user can now execute the queries without encountering the error.
  
  
  
  Related Information:
  
  Transaction Codes:
  
  SU01: User Maintenance
  PFCG: Role Maintenance
  RSECADMIN: BW Authorization Management
  
  
  Authorization Objects: Familiarize yourself with the relevant authorization objects for BW analysis, such as S_BI_WA (BW Analysis Authorizations).
  Documentation: Refer to SAP Help documentation for detailed information on BW authorizations and best practices for managing user access.
  
  By following these steps, you should be able to resolve the RS2HANA_CHECK110 error and ensure that users have the necessary authorizations to access BW data.