SAP Knowledge Base Article - Public

3599940 - Error when adding a filter or aggregation to a Calculated Column in Graphic View Editor

Symptom

In Graphic View Editor, when you add a filter or aggregation to a Calculated Column, error happens: "The expression is using a calculated column which uses window function."

Environment

  • SAP Datasphere

Reproducing the Issue

  1. Open Graphic View Editor;
  2. Add source table;
  3. Create Calculated Column, add formula e.g. ROW_NUMBER;
  4. Add filter to the created Calculated Column in Step 3.

Resolution

In graphical view editor, window functions are not allowed in filter and aggregation nodes.
Please refer to note after "Window Function" section in the SAP Help Doc (SQL Functions Reference | SAP Help Portal)

It's suggested to use SQL View Transform to achieve the same, as there is no such restriction in SQL view transform.

Keywords

KBA , DS-DI-VIW , View Persistency and Runtime , DS-DI-TRF , Transformation Flows , How To

Product

SAP Datasphere all versions