SAP Knowledge Base Article - Public

2761862 - CDS views do not appear when creating a model using an import or live connection to SAP S/4HANA Cloud in SAP Analytics Cloud (SAC)

Symptom

  • CDS views do not appear when creating a model using an import or live connection to SAP S/4HANA Cloud in SAP Analytics Cloud (SAC).
  • The "@Analytics.query: true" Annotation has been added to all the CDS Views.
  • The CDS views appear in the response of the URL:
    • https://<S4HANACloud>/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/ServiceCollection

Environment

  • SAP Analytics Cloud 2019.5.1

Reproducing the Issue

  1. Create a model using an import S4HANA Cloud connection.
  2. Choose Create a new query.
  3. Only part of CDS Views shows in the list.

Cause

SAP Analytics Cloud uses the following arguments when querying CDS views:

  • ServiceCollection?$format=json&$select=Title,Description,EntitySets/ID,EntitySets/Description&$expand=EntitySets

If a CDS view is not returned or it has no EntitySets below it in the result set, SAC will not show that CDS view, which is a by design behavior at the moment this KBA was created.

Resolution

Make sure the CDS views are exposed from the S/4HANA Cloud side or check whether this is only an issue for the given service.

See Also

Your feedback is important to help us improve our knowledge base.

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 , KBA , transactional cds views not working thro , views not working through sac , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , XX-S4C-RLS , S/4HANA Cloud support authorizations , Problem

Product

SAP Analytics Cloud 1.0