Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
uladzislau_pralat
Contributor
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



 

 

 

 

 

 

 

 

 
2 Comments