Symptom
Cannot access Core Data Services (CDS) View from SAP S/4HANA in SAP Analytics Cloud (SAC)
Environment
- SAP Analytics Cloud
- SAP S/4HANA
Reproducing the Issue
- Connect to SAP Analytics Cloud.
- Configure a Live Data Connection to SAP S/4HANA.
- Create a new live S/4HANA model.
- Notice that some of the basic CDS views do not appear.
Cause
SAP Analytics Cloud only consumes Core Data Services (CDS) Views from S/4HANA with certain attributes:
- Contain the "@Analytics.query: true" Annotation
- API-state=released
Resolution
SAP S/4HANA "On Premise"
- The SAP S/4HANA administrator must use the ABAP Development Tools for SAP NetWeaver to add the "@Analytics.query: true" Annotation to the required CDS Views
- Additional documentation at:
SAP S/4HANA Cloud
- In SAP S/4HANA Cloud, a view, namely a query, that is not released for customer usage (API-state=not released) is not available to customers for creating own CDS-views.
- The option for a customer is to create a custom Query on a released CDS-View of type “CUBE”, using the app “Custom Analytical Queries”.
- Additional documentation at:
- Live Connection: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/0485d540e0b340a0bc0da86fe368997c.html
- Links out to: https://help.sap.com/viewer/f544846954f24b9183eddadcc41bdc3b/latest/en-US/ddbc64b5c7d64892ad9f848e91a8b45e.html
- Import Data Connection: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/63140f17362947fe8bcd9c6960db23bc.html
See Also
- 2769322 - Some OData Services / APIs in SAP S/4HANA system do not appear when creating a new model in SAP Analytics Cloud (SAC)
- 2710858 - Custom Analytical Queries are not visible in SAP Analytics Cloud system
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning,Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, CDS, view, authorization, show, up, hidden, find, access, role, standard, permission, annotation, core, data, services , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-BICS-INA , BW INA provider , Problem