SAP Knowledge Base Article - Public

3246792 - Cannot output sum aggregation with Custom CDS Views - SAP S/4HANA Cloud Public Edition

Symptom

An item that outputs the total value for each aggregate key in the custom CDS View output item is to be created. However, even if "Sum" is set for Aggregation, the total value cannot be output as expected.

Environment

SAP S/4HANA Cloud Public Edition

Cause

Unfortunately, aggregations cannot be achieved through the Custom CDS views app, this is a limitation. Aggregations are used to define the interpretation of numeric data e.g. in an analytical scenario. As a result to setting an aggregation, a field is e.g. interpreted as measure when using it in a custom analytical query later on. That's why defining an aggregation behavior for each numeric field in an analytical scenario is a must, except for the representative key. Optionally, timestamps and dates can also be defined as measures if this is required for business case.

Resolution

The aggregations are only covered in the analytical scenario together with Custom Analytical Queries app. There are no plans to include this functionality in the Custom CDS Views app. But it should be possible to achieve it with developer extensibility.

See Also

For more conceptual details, about analytical scenarios, refer to Analytical Scenarios: Dimensions and Cubes.

For more information about what to take into account and about how to create dimensions and cubes, refer to Creating a Dimension and Creating a Cube.

For more information, refer to 3201919 - Custom CDS Views – Frequently Asked Questions

Keywords

sum, aggregation, custom cds views, analytical scenarios, output, query , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem

Product

SAP S/4HANA Cloud Public Edition all versions