3624159 - Unable to Hide Unit of Measure or Currency in Custom Analytical Query Report Preview

In the Custom Analytical Query report, the key figure values are displayed with their respective units or currencies (e.g., 1.23 KG or 100.00 USD). However, it is not possible to preview the report without displaying the unit of measure or currency.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP S/4HANA Cloud Public Edition

To hide the unit of measure or currency in the report preview, the NODIM() function must be used. This function is supported in the Custom Analytical Queries app and allows the display of numeric values without associated units or currencies.

To apply this, a new Calculated Measure must be created, Follow the steps below to create a calculated measure 

1. Open the Custom Analytical Queries app.
2. Search for the query YY1_XXXX.
3. Click on Edit.
4. Navigate to the 'Display' tab.
5. Click on Add and Select 'Add Calculated Measure'.
6. Enter a label for the new measure.
7. In the Expression, use the formula: NODIM( <expression> ).

This will display the numeric value without the associated unit or currency in the report preview.

hide unit of measure, custom analytical query, sap s/4hana cloud, calculated field, extensibility, Custom CDS view, Preview, Query report, how to hide unit in report, How to remove units from report preview, Report, Analytical query preview, Calculated measure, CDS view report , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem