2828688 - Unable to build model on any standard OData service through import data connection to SAP S/4HANA in SAP Analytics Cloud (SAC)

• 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}

• SAP Analytics Cloud (Enterprise)

1. Log on to SAC tenant.
2. Create one import data connection to SAP S/4HANA on-premise system.
3. 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.

• The standard OData service has fixed client (here, take 100 as example), which can be verified by:
1. Log on to S/4HANA system.
2. Run T-Code SICF and then enter Service Name to Execute.
3. 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 service from browser by specifying different sap-client in the URL.
• But it is impossible to specify 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, does not help since anything following the "?" is only used for authentication and does not affect queries.

• Change the client of those standard OData services 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.

• 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 case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
• https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
• https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.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 Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

Your feedback is important to help us improve our knowledge base.

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, 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, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, , KBA , unable to connect to s4 , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem