/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
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
SAP Datasphere all versions
Attachments
| Preview.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)