SAP Knowledge Base Article - Public

2769322 - Some of OData Services in S4HANA system are not shown when creating new Model in SAP Analytics Cloud (SAC)

Symptom

Some of OData Services in S4HANA system are not shown when creating new Model in SAP Analytics Cloud (SAC)

Environment

SAC 2019.5

Reproducing the Issue

  1. Create a new SAP S/4HANA connection in SAC.
  2. Try to create a new Model on the top of new connection.
  3. Some of the ODATA service 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 invisible service confirm its Service ID in S4/HANA. 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 the service is now shown in the result list.

Fix:

This issue is now planned to be fixed in 2019.9 version in future.

See Also

2710858 - Custom Analytical Queries are not visible in SAP Analytics Cloud system

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 , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

Product

SAP Analytics Cloud all versions