Creating SAP BW Unit of Measure Conversion Definitions

SAP BW converts data value unit of measure ad hoc during analysis, and saves conversion definitions as analysis tools. You can activate and deactivate unit of measure conversion definitions without removing them from the Analysis Tools Manager, enabling unit of measure combinations that differ.

Note:

To use the Unit of Measure Conversion analysis tool, the 0MATERIAL characteristic must be selected as a data object column, row, or page dimension.

  To convert all units of a measure to another unit of measure:

  1. Right-click a dimension member header and select Analysis Tools, then Unit of Measure Conversion.

    The SAP Unit Conversion dialog box is displayed.

  2. From the Unit From list, select a unit of measure that you would like to convert.

  3. From the Unit To list, select the unit of measure into which you would like your previous selection converted.

    The drop-down list displays known conversion rates from your SAP BW 0MAT_UNIT table. You must define a logical conversion for the analysis tool to work.

  4. Optional: To define a custom unit of measure conversion using these steps:

    1. From the Unit To list, select Custom Unit.

    2. In Select Custom to Rate, enter a unit name in Unit Name.

    3. Enter a custom conversion factor in Conversion Factor.

  5. Click OK.

    All data values using the specified unit of measure are converted using the standard or custom conversion rate. Repeat this process to convert all data values to one unit of measure.