Quantity conversion in Bex

[Former Member]

Dear Experts,

I am working on BI7 and I am trying to convert each (EA) in piece (PCE) - or others - in my queries.

I created my quantity conversion type using central units of measure (T006) such as source unit of measure comes from data record and target quantity comes from variable selection.

In my query, when trying to convert, the system says "quantity conversion not possible".

How can I solve my problem?

[Former Member · Accepted solution]

Hi,

Try to create a new formula InfoObject in the structure with NODIM() function and first calculate your required keyfigure with out any units, later copy this KeyFigure and set the required unit to it.

Cheers.

Ranga

Message was edited by:

Ranga

[Former Member]

Take a look at these threads & see if they are helpful...

/message/3532362#3532362 [original link is broken]

http://help.sap.com/saphelp_bw30b/helpdata/en/03/17f13a2f160f28e10000000a114084/content.htm

[Former Member]

Hi

Use formula like this

NODIM ( quantity ) * Cost

or

quantity * NODIM ( cost )

Try NODIM and NODIV ( as suggested by previous post )

You will get the results in the units you want

Regards

N Ganesh