Presenting Percent Values in S/4 HANA Embedded Analytics Made Easy

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

Define Z% Customer Percent Unit of Measure in SAP Customizing

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. %

Define PercentUnitOfMeasure Dimension Referring Z% Customer Percent Unit of Measure in CDS Cube

Define HundredPercent Measure Referring PercentUnitOfMeasure Dimension in CDS Cube

Define SeatsOccRate Formula That Is a Ratio Multiplied by HundredPercent Measure in CDS View