Symptom
- Unable to build model with OData service through import data connection to SAP S/4HANA in SAP Analytics Cloud (SAC).
- After selecting one entity, the query panel cannot be shown.
- The following error message occurs in Chrome Development Tools:
{"messageId":"AUTHENTICATION_ERROR","message":"Unable to connect to datasource. Check the connection details and user credentials, and then try again.","bUIMessage":false,"bWarning":false,"customData":"Authentication failure. Try authenticating again.(If this is using a shared connection without credentials, please enter the credentials by running a data import using such connection)","status":401}
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Log on to SAC tenant.
- Create one import data connection to SAP S/4HANA On Premise system.
- Try to create a new model on the connection and then choose one entity from any standard OData service exposed from the S/4HANA On Premise system.
=> The query panel cannot be shown and it is impossible to build model.
Cause
- The standard OData service has fixed client (here, take 100 as example), which can be verified by:
- Log on to S/4HANA system.
- Run T-Code SICF and then enter Service Name to Execute.
- Double click the OData service from list and then switch to Logon Data tab.
=> If right-clicking the Odata service to select Test Service, it will open the OData service in browser with "?sap-client=100".
=> Without specifying client number in the URL, it works in the fixed client as above. - However, the S/4HANA user in the import data connection doesn't have access to client 100, so the user cannot access the Odata service with "?sap-client=100".
- The user can only access the OData serivice from browser by specifying different sap-client in the URL.
- But it is impossible to sepcify different sap-client for the individual OData service when creating model from SAC.
- Even setting "?sap-client=<...>" in the Data Service URL of import data connection, it doesn't make help since anything following "?" is only used for authentication and will not affect queries.
Resolution
- Change the client of those standard OData service to other client number, on which the S/4HANA user has access.
OR - Use another S/4HANA user having access to client 100 in the import data connection.
See Also
- 2590508 - Import or Export Data from/to SAP S/4HANA to/from SAP Analytics Cloud
- 2628688 - OData service connection in SAP Analytics Cloud ***Master KBA***
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, 401, S4, S4HANA, S/4HANA, AUTHENTICATION_ERROR, credentials, Authentication, client, sap-client , KBA , unable to connect to s4 , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem