BEx Output in Kilograms or US Pounds

[Former Member]

Hello,

All of the quantity data in our cube is in Kilograms, is there a way to allow the user to select Kilograms or US Pounds for quantities? The difficult part is the units associated with the quantity should appear in Excel as KG when the user selects KG, and LB (pounds) when the user selects pounds.

The paper "How to Report Data in Alternate Units of Measure" is much more extensive than we would like, it is inefficient (a select for each distinct 0MATERIAL), requires a change to SAP standard function module, and requires maintenance of all material units in pounds. We were hoping for a simpler solution.

Thanks for your input!

[jaya_mogali · Accepted solution]

Hi Larry,

If you already have data in KG you can convert to US pounds using calculated KF.

Now create a text variable where user can enter KG or LB.

Create a formula varaible using customer exit which will read the text variable entered and will pass a value for example 1 for KG and 2 for LB.

Use this customer Exit formula variable in another CKF and create a if condition to display either QuantityKG or Quantity LB based on text variable entered. Use the text variable in the description of the calculated KF.

Jaya

[Former Member · Accepted solution]

Thanks for your input Jaya.

But our users would like to see all of the key figures in the column with the unit LB (not just the heading). Is there some way to pass units back (KG or LB) from a customer exit? For example, it would be nice to be able to return:

1 KG if the user selects "KG"

2.2046 LB if the user selects "LB"

Then

NODIM( Qty) * UserVar

would return the correct units. But I'm not sure how to get units back from a customer exit.

[jaya_mogali · Accepted solution]

Hi Larry,

You can use the approach that you mentioned in your post but I am not sure how to pass variable Units ( KG or LB) for the quantity in the cutomer exit.

In my approach the result is always with correct units.

You are using text varible for selecting KG or LB .

As mentoned in my earlier reply you have to create two CKFs(global).

1. Quantity LB = NODIM(Qty KG ) * 2.2046 LB ( 2.2046 is a formula variable with units LB)

2. Create a text variable user input mandatory for entering KG or LB. lets say " TEXTKGLB"

3. Create a cust exit variable say "READKGLB" to read TEXT variable "TEXTKGLB" and will pass a value 1 for KG and 2 for LB

4, Create 2nd CKF - Description Quantity &TEXTKGLB& and use following formula. (READKGLB==1)* Qty KG + ( READKGLB ==2) * Quantity LB .

In the query you have to use the CKF Quantity &TEXTKGLB& . This will display the desired result with correct units.

Jaya

[Former Member]

It works! Thanks for your help.