How to remove Unit of Measure from Query Results

[Former Member]

Hi All,

We are running a SAP BI Query (SAP BI 7) and the query displays the key figure (Restricted key figure based on 0QUANTITY) but it also displays the Unit of Measure i.e which is Employees (EPL) as part of the result.

i.e 15 EPL

We would like to remove the "EPL" to just show the base figure i.e "15" only not "15 EPL".

I know that this can be achieved by using the NODIM() formula and putting the Restricted Key Figure inside this formula as a new Calculated Key figure but would like to know if it is possible by any setting rather than using NODIM().

The Key Figure is part of a structure of many other key figures and it would be useful to know if it can be done without using NODIM() formula.

Thankyou kindly in advance.

Stevo.

[former_member222556 · Accepted solution]

Hi Dear,

As you said, you don't want to apply NODIM() funtion on the Calculated Key Fig. bacause it is already used some other query.

so simply drag your caculated Key Fig. in the Column and set the Display property of calculated key fig as Alway Hide and

create a new local formula by right click in the column and write:-

NODIM ( "Your caculated Key Fig." ).

this will not affect your calculated Key fig. and also remove Unit .

check with this code and let me your result....

[Former Member]

the best is

since your RKF is getting used everywhere ( make change in RKF definition only

create new CKF and with no dim.

then used this CKF in the old RKF INSTEAD OF 0quantity.

[Former Member]

CREATE NEW CALCULATED KEY FIGURE DRAG THE RESTRICTED KEY FIGURE AND APPLY THE (NO DIM() )FUNCTIONS IN FUNCTIONS . NO DIM CORRESPONDS TO NO DIMENSIONAL UNIT.

USE THIS CALCULATED KEY FIGURE WHICH IS DERIVED FROM RESTRICTED KEY FIGURE USE THIS CALCULATED KEY FIGURE IN THE QUERY SO THE RESULT WILL NO UNIT

[former_member189638]

I don't think it is not possible to do without NODIM function.....because if you try to remove 0UNIT you will get ERR after the key fig value (e.g. 15 ERR).