SAP Knowledge Base Article - Public

3150290 - CDS views from S/4 HANA Cloud are not visible when creating a model in SAP Analytics Cloud (SAC)

Symptom

  • CDS views from S/4 HANA Cloud are not visible when creating a model in SAP Analytics Cloud (SAC).

Environment

  • SAP Analytics Cloud (Enterprise) 2021.20

Reproducing the Issue

  1. Create a new model from SAP S/4 HANA.
  2. 'New Query for SAP S/4HANA' window appears.
  3. Choose available connection.
  4. Try to search for any of the CDS views.
  5. Observe only some of them can be found.

Cause

Currently S4 is using the Discovery Service to find all OData Services as well as the Entities under them. The Discovery Service Gateway will only return Services with Entities if the Entities have previously been cached. If a Service did not have the Entities cached, then it would return as if it did not have any Entities. SAC will filter out Services that don't have Entities and as a result, it may appear like certain Services are missing.

Resolution

To have the Entities cached, the metadata ($metadata) for the individual Service must have been requested first.

Using your browser, navigate to the Service URL of the missing service, and append /$metadata to the end of the url. Authenticate with the Basic Authentication credentials you have defined in your communication arrangement with SAC and observe the page has returned a XML response.
Next, try to create a new model from SAP S/4 HANA in SAP Analytics Cloud and the CDS will show up when expanding the service folder in the selection dialog or when using the search box.

URL Example: https://my301739-api.s4hana.ondemand.com/sap/opu/odata/sap/MY_NEW_CDS/$metadata.

You should be able to find this URL inside S/4 HANA UI -> Communication Arrangement -> Inbound Services -> Service URL list.

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, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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 , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud 1.0