SAP Knowledge Base Article - Public

2595552 - Cannot access Core Data Services (CDS) View from SAP S/4HANA in SAP Analytics Cloud (SAC)

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

  1. Connect to SAP Analytics Cloud
  2. Configure a Live Data Connection to SAP S/4HANA
  3. Create a new Model
  4. Notice that some of the basic CDS Views do not show up

Cause

SAP Analytics Cloud only consumes Core Data Services (CDS) Views from S/4HANA that contain the "@Analytics.query: true" Annotation

Resolution

S/4 HANA Administrator must use the ABAP Development Tools for SAP NetWeaver to add the "@Analytics.query: true" Annotation to the required CDS Views

For S/4HANA version 1802 it is also required to set the ‘API state’ to ‘Released’

  1. Install the ABAP Development Tools for SAP NetWeaver: https://tools.hana.ondemand.com/#abap
  2. Launch Eclipse
  3. Click "Window | Perspective > Open Perspective > Other..."
  4. Select "ABAP" and click "OK"
  5. If you already have an ABAP Project then skip to step 7.
  6. Click "File | New > ABAP Project"
    • Select SAP Logon entry for your system
    • Click "Next >"
    • Verify Connection Settings and click "Next >"
    • Client: <Your Client e.g. 000 or 001 or 100>
    • User: <Your User>
    • Password: <Your Password>
    • Language: <Your Language>
    • Project Name: <Accept the default or customize the project name>
    • Click "Finish"
  7. Click "Search | Search..."
  8. Logon if/when prompted
  9. On the "ABAP Object Search" tab search for your CDS View
  10. In the Search result pane double-click your CDS view
  11. In the Properties tab click "API State"
  12. Click "Change"
  13. Check "Released" and click "Next >"
  14. Click "Finish"

See Also

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana 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 , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0