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
Keywords
average, currency conversion, SUM, standard aggregation , KBA , DS-MD-AM , Analytic Model , Problem
Product
Attachments
Preview.png |
Pasted image.png |
Pasted image.png |
Pasted image.png |
Pasted image.png |