SAP Knowledge Base Article - Public

3475295 - Some columns are showing "*" in Custom Analytical Query preview

Symptom

You have created a Custom Analytical Query based on a Custom CDS View and when previewing it, some columns/measures are showing "*" instead of the real element value.

Environment

SAP S/4HANA Cloud 

Reproducing the Issue

  1. Open Custom Analytical Query app
  2. Search for the Query
  3. Click on "preview"
  4. Check the specific column

Cause

You have not configured an aggregation for the element in the Custom CDS Views app.

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 you use it in a custom analytical query later on. That's why you must define an aggregation behavior for each numeric field in an analytical scenario, except for the representative key. 

 

 

Resolution

In order to show the correct amount, you need to edit the Custom CDS View on which the Query is based and add the aggregation. 

See Also

For more information, you can check SAP Help Portal | Element Properties.

Keywords

custom analytical query, custom cds view, queries, column, row, measure, *, asterisc, aggregation, sum, summing, value, data, not correct , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

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