SAP Knowledge Base Article - Public

2769322 - Some OData Services / APIs in SAP S/4HANA system do not appear when creating a new model in SAP Analytics Cloud (SAC)

Symptom

Some OData Services / APIs /CDS views in SAP S/4HANA system do not appear when creating a new model in SAP Analytics Cloud (SAC).

Environment

SAP Analytics Cloud 2019.5

Reproducing the Issue

  1. Create a new SAP S/4HANA connection in SAC.
  2. Create a new Model with the new connection.
  3. Some OData services in S/4HANA are not shown in the Query panel list.
  4. Refreshing the list or searching by some specific key word may not solve the issue.

Cause

The root cause is gateway OData results do not reflect the real-time data unless user has to first manually hit individual service $metadata.

Resolution

Workaround:

  1. For each missing (not visible) service, confirm its service ID in S/4HANA. For example: API_FINPROJECT_SRV
  2. In the same browser access its URL "https://<S4System>/sap/opu/odata/sap/<ServiceID>/$metadata" directly.
  3. Need to log on with SAC_IN_COMM_USER account when accessing the URL.
  4. Confirmed the service metadata is loaded in the page as XML format.
  5. Go back to SAC tab in same browser, search the service with its name again.
  6. Check that the service appears in the result list.

Fix:

This issue is resolved in version 2019.9.

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, server, service, services, visible, invisible, hide, hidden, OData, Open Data Protocol, S4HC Scope Item 1YB - no queries available, We can not choose the APIs in SAC , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , Problem

Product

SAP Analytics Cloud all versions