SAP Knowledge Base Article - Public

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

Symptom

  • Unable to build model on any standard 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 can be observed 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 2019

Reproducing the Issue

  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.

Cause

  • The standard OData service has fixed client as 100.
  • However, the S/4HANA user in the import data connection doesn't have access to client 100.
  • 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

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 , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0