Some OData Services / APIs /CDS views in SAP S/4HANA system do not appear when creating a new model in SAP Analytics Cloud (SAC).
SAP Analytics Cloud 2019.5
Reproducing the Issue
- Create a new SAP S/4HANA connection in SAC.
- Create a new Model with the new connection.
- Some OData services in S/4HANA are not shown in the Query panel list.
- Refreshing the list or searching by some specific key word may not solve the issue.
The root cause is gateway OData results do not reflect the real-time data unless user has to first manually hit individual service $metadata.
- For each missing (not visible) service, confirm its service ID in S/4HANA. For example: API_FINPROJECT_SRV
- In the same browser access its URL "https://<S4System>/sap/opu/odata/sap/<ServiceID>/$metadata" directly.
- Need to log on with SAC_IN_COMM_USER account when accessing the URL.
- Confirmed the service metadata is loaded in the page as XML format.
- Go back to SAC tab in same browser, search the service with its name again.
- Check that the service appears in the result list.
This issue is resolved in version 2019.9.
- 2595552 - Cannot access Core Data Services (CDS) View from SAP S/4HANA in SAP Analytics Cloud (SAC)
- 2710858 - Custom Analytical Queries are not visible in SAP Analytics Cloud system
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
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