Skip to Content

Unit Conversion

Hi Experts,

I have an issue in the update rules from the ODs to Cube.For the Data source 0CO_OM_NWA_2-Delta extraction Netw. Activity Actual Costs.. there is a Field MBGBTR(Consumption qty enterd) mapped in Transfer rules to BW object BQTY_ENT. but not mapped in Infosurce to ODS level.

Agaign this BQTY_ENT is mapped in ODs to Cube level.

Since this was not mapped in infosurce level the data for Qty is not updating in Cube currently.

Also When i check the update rules from ODs to Cube, the rule is in Yellow colour.. with warning messages "Target unit and source unit for key figure Quantity are different".Because the keyfigure BQTY_ENT(unit=BUNIT_ENT)-in ODS is mapped to 0Quantity(0unit) in cube have diffent units.

So does this requires any conversion unit conversion routine for this?If so Can anyone please advise how to write the routine.

Thanks for the help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2012 at 08:49 AM

    Hello Anil,

    As per my understanding, 0Quantity+0UNIT of measure and 0BQTY_ENT+0BASE_UNIT

    Quantity can contain any unit values eg kg,ton etc.

    0BQTY_ENT is used for base unit of measure for material.

    You can convert other units to base unit by multiple the KF Value * 0NUMERATOR/0DENOMINTR in the field level rountine.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.