Symptom
-
Calculated field is not considered as a key figure "aggregation" property under "Field Properties" tab is not selectable
- When publishing a Custom View, system is automatically adding XXX as the name of my custom field. Therefore user is not able to edit this field anymore
Environment
SAP S/4HANA Cloud Public Edition 1708
Reproducing the Issue
-
Create a custom view
-
Pick one of the datasource XXXX as the primary datasource
-
Pick some of the fields, and then add a calculated field
-
Name the calculated field XYZ and put 1 as the value
-
Go to Field properties
-
Aggregation is blank
-
Publish this view
-
Log out, log back in and try to edit the custom view
-
Not able to change the calculated field
Cause
This is expected behavior.
Resolution
- Aggregations on calculated fields are currently not possible. User can build a query with the "Analytical Query Designer" on top of the view
- A formula "put 1 as the value" is not valid and lead to the issue that cannot change the field. This will be addressed within one of the next releases. As a workaround, user can use a formula "0+1" instead of "1"
-
It is not possible to add an aggregation to a calculated field right now, as this is not fully supported in the analytics runtime
Keywords
Calculated Field Custom view, aggregation calculated field , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem