This website is not affiliated with, sponsored by, or approved by SAP AG.

How to remove Unit of Measure from Query Results

Business Warehouse

Moderators: Snowy, thx4allthefish

How to remove Unit of Measure from Query Results

Postby bw4eva » Thu Jan 20, 2011 9:41 am

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.
bw4eva
 
Posts: 32
Joined: Sat Jul 05, 2008 6:49 am

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 2 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.