Presenting percent values in S/4 HANA Embedded Analytics is a challenge.
On one hand decimal values without unit of measure are displayed correctly in Smart Business, but not in Query Browser
On the other hand percent values with % unit of measure are displayed correctly Query Browser, but not in Smart Business
In this blog I will explain how to model CDS View percent measure in such a way that is displayed perfectly fine in both Smart Business and Query Browser.
This what it takes to model percent measure:
- Define Z% customer percent unit of measure in SAP Customizing;
- Define PercentUnitOfMeasure dimension referring Z% customer percent unit of measure in CDS cube;
- Define HundredPercent measure referring PercentUnitOfMeasure dimension in cube CDS view;
- Define SeatsOccRate formula that is a ratio multiplied by HundredPercent measure in CDS view.
Percent measure created as explained above is displayed correctly in both Smart Business and Query Browser
In trx. CUNI (SPRO-> SAP Net Weaver-> General Settings ->Check units of measurement)
Note: SAP enforces external unit of measure presentation to be unique, to differentiate it from standard percent unit of measure presentation it is necessary to add No-Break Space to have the same presentation as standard on e.g. %