Skip to Content
Technical Articles

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:

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

 

 

 

 

 

 

 

 

 

1 Comment
You must be Logged on to comment or reply to a post.