SAP Knowledge Base Article - Public

3303477 - Error "View must contain at least one measure" when creating a custom CDS view of type Analytical Cube - SAP S/4HANA Cloud

Symptom

Error "View must contain at least one measure" occurs when creating a Custom CDS View of type Analytical Cube.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  1. Create a new Custom CDS View of type Analytical Cube
  2. Choose an analytical data source
  3. Error "View must contain at least one measure" occurs

Cause

Analytical Cube views must have a measure. Error occurs because no measure element has been included in the Custom CDS View. 

Resolution

Add a numeric element which is a measure with an aggregation to include in the view or create a CDS View of Analytical Dimension type.

See Also

2657021 - Creating Custom CDS Views for Analytical Scenarios 

Keywords

analytical cube, custom cds view, View must contain at least one measure , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions