Friday 14 June 2019

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


SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

On the other hand percent values with % unit of measure are displayed correctly Query Browser, but not in Smart Business

SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

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

SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

Define Z% Customer Percent Unit of Measure in SAP Customizing

In trx. CUNI (SPRO-> SAP Net Weaver-> General Settings ->Check units of measurement)

SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

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

SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

Define HundredPercent Measure Referring PercentUnitOfMeasure Dimension in CDS Cube

SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

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

SAP ABAP Certifications, SAP ABAP Study Materials, SAP ABAP Guides

No comments:

Post a Comment