SAP Knowledge Base Article - Public

3448776 - Measure with Standard Aggregation AVG does not work in SAP Datasphere Analytic Model

Symptom

When creating an Analytic Model in SAP Datasphere and setting a measure's Aggregation Type to AVG, the preview does not show the currency/unit. 

 

Preview results: 

Environment

SAP Datasphere 

Resolution

The issue will be fixed from SAP HANA Cloud 2024.2 (QRC1/2024). Please check SAP Note 3220622 for further details concerning the upgrade of your SAP Datasphere system to this release.

As workaround you can rebuild the standard aggregation AVG using a SUM measure and dividing it by a COUNT distinct measure or a restricted measure with exception aggregation COUNT. As dimension you need to choose the key field of your fact source.

See Also

Add Measures | SAP Help Portal

Create a Currency Conversion Measure | SAP Help Portal

Keywords

average, currency conversion, SUM, standard aggregation , KBA , DS-MD-AM , Analytic Model , Problem

Product

SAP Datasphere all versions

Attachments

Preview.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png