SAP Knowledge Base Article - Public

3227982 - Custom CDS View is not appearing in Custom Analytical Query for selection - SAP S/4HANA Cloud

Symptom

When trying to use a Custom CDS View in a Query, it is not available for selection in Custom Analytical Queries app. 

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  1. Go to "Custom Analytical Queries" app.
  2. Click on "Create" button.
  3. In "Select Data Source" the Custom CDS View is not available.

Cause

The Custom CDS View doesn't have an Analytical Scenario (e.g. Standard CDS View, External API).

Resolution

It's only possible to select Custom CDS View as a data source of a query, if it has an Analytical Scenario. Hence it's necessary to create a new Custom CDS View with an Analytical Cube or Analytical Dimension scenario.

See Also

Creating Custom CDS Views for Analytical Scenarios – Modelling Rules

Keywords

Custom CDS Views, Custom Analytical Queries, query, CDS view, data source, not available, doesn't exist, doesn't appear, selection , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

Product

SAP S/4HANA Cloud Public Edition all versions