SAP Knowledge Base Article - Public

3524772 - Custom CDS view created in ABAP Development Tools is not available for selection in Custom Analytical Queries app - SAP S/4ANA Cloud

Symptom

  • Custom CDS view created in ADT is not available for selection as data source in Custom Analytical Queries app
  • Custom view has annotation @Analytics.query: TRUE

Environment

SAP S/4HANA Cloud

Cause

The annotation required for making an ADT-created CDS view visible in the data source list is @Analytics.dataCategory: #CUBE

Resolution

  1. In your view, remove the annotation @Analytics.query: TRUE
  2. Add the annotation @Analytics.dataCategory: #CUBE
    • Note: If this gives errors on activation, you may need to adapt underlying views accordingly to fix the errors
  3. Make sure the view is active and released for use in key user extensibility
  4. It should then be visible in the data source list.

See Also

Develop and Consume Queries on SAP Analytics Cloud | SAP Tutorials

🟢 Introduction to Embedded Analytics with ABAP Cloud (youtube.com)

Using Service Binding Editor for InA Service | SAP Help Portal

Keywords

custom cds view adt abap development tools annotation analytics query custom analytical queries data source , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud Public Edition all versions