How To Fix RS2HANA_CHECK105 - User is not authorized on InfoProvider &1 (HANAMODELFL &2)

SAP Error Message - Details

• Message type: E = Error

• Message class: RS2HANA_CHECK - RS2HANA Check Report

• Message number: 105

• Message text: User is not authorized on InfoProvider &1 (HANAMODELFL &2)

What causes this issue?

No proper authorizations are maintained for BW user &V3& and InfoObject
&V1&. You need to maintain a specific type of authorizations in BW,
based on the BW object type and generated external SAP HANA view. For an
<ZH>External SAP HANA View for Master Data</> you have to maintain
proper authorizations using authorization object S_TABU_LIN. For more
information, refer to http://help.sap.com/saphelp_nw74/helpdata/en/7a/6e
c03e7856b300e10000000a114084/frameset.htm
You have enabled the <ZH>Evaluate Analysis Authorizations </>settings in
SAP BW customizing (transaction SPRO). This means you also have to
maintain proper BW analysis authorizations<(>,<)> which are combined
with the maintained S_TABU_LIN authorizations when replicating the
authorizations from SAP BW to SAP HANA. This does not apply to the
external SAP HANA view for master data for InfoObject &V1&.
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
&V3& and InfoObject &V1& 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 Master Data</> (InfoObject): Run function
module RSEC_GET_AUTH_FOR_USER_MDATA. Enter the InfoObject and BW user as
importing parameters.
<ZH>External SAP HANA View for Reporting</> (BW Query): Run function
module RSSB_AUTHORITY_COMP_CHECK. Enter the InfoArea of the underlying
InfoProvider, the underlying InfoProvider, the query type, the query ID,
the query owner, activity as 03 (display) and BW user as importing
parameters.
<ZH>External SAP HANA View for Reporting</> (all other BW InfoProviders
including InfoObjects and InfoObjects with external SAP HANA View for
Master Data when the setting <ZH>Evaluate Analysis Authorizations </>is
enabled): 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_CHECK105 - User is not authorized on InfoProvider &1 (HANAMODELFL &2) ?

  The SAP error message RS2HANA_CHECK105 indicates that a user is not authorized to access a specific InfoProvider in SAP HANA. This error typically arises when a user attempts to execute a query or access data from an InfoProvider (in this case, a HANA model) for which they do not have the necessary authorizations.
  Cause:
  
  Lack of Authorization: The user does not have the required roles or authorizations assigned to access the specified InfoProvider.
  Role Assignment Issues: The roles that contain the necessary authorizations may not be assigned to the user.
  InfoProvider Configuration: The InfoProvider may have specific authorization restrictions that prevent access.
  
  Solution:
  
  
  Check User Roles:
  
  Go to the user management transaction (e.g., SU01) and check the roles assigned to the user.
  Ensure that the user has the appropriate roles that include access to the InfoProvider in question.
  
  
  
  Review Authorization Objects:
  
  Identify the authorization objects related to the InfoProvider and ensure that the user has the necessary authorizations.
  Common authorization objects for HANA models include S_RS_AUTH and S_RS_COMP for reporting and data access.
  
  
  
  Assign Missing Roles:
  
  If the user lacks the necessary roles, assign the appropriate roles that provide access to the InfoProvider.
  You may need to work with your SAP security team to ensure that the correct roles are created and assigned.
  
  
  
  Check InfoProvider Settings:
  
  Review the settings of the InfoProvider to ensure that there are no additional restrictions or settings that could be causing the authorization issue.
  
  
  
  Testing:
  
  After making changes, have the user log out and log back in to ensure that the new authorizations take effect.
  Test the access to the InfoProvider again to confirm that the issue is resolved.
  
  
  
  Related Information:
  
  
  Transaction Codes:
  
  SU01: User Maintenance
  PFCG: Role Maintenance
  SU53: Display Authorization Check (to analyze authorization issues)
  
  
  
  Documentation: Refer to SAP documentation on authorization concepts and best practices for managing user roles and authorizations in SAP BW and HANA.
  
  
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to authorization errors in HANA models.
  
  
  By following these steps, you should be able to resolve the RS2HANA_CHECK105 error and ensure that the user has the necessary access to the InfoProvider.