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**

Nice posting Ulad. Thank you.

Nice Blog Ulad, Thanks.