Quantity conversion during the transformation enables you to convert data records from the source unit of measure into a unit of measure of the target of the transformation.
Quantity conversion in the transformation is generally performed using previously defined conversion types. For more information, see Quantity Conversion Types.
Where required, you can perform quantity conversion with user-defined subprograms (formulas and routines). It is not currently possible to execute quantity conversion for DataStore objects using predefined conversion types. You have to use routines instead.
Depending on the type of unit of measure, there are two different types of key figures:
1. Key figures with fixed unit of measure
With a fixed unit of measure, the unit is fixed for the key figure. The key figure refers specifically to the unit of measure so the unit does not have to be entered again in the data record.
2. Key figures with variable unit of measure
A variable unit of measure references an InfoObject.
For more information, see Creating InfoObjects: Key Figures.
Transformations can be performed for key figures in two ways:
1. Every key figure in an InfoCube (target key figure) has a corresponding key figure in the source (source key figure). Quantity conversion is not performed.
2. There is no corresponding source key figure in the InfoSource for the target key figure in the InfoCube.
a. You can assign a source key figure of the same type to the target key figure.
■ If the units of measure of both key figures are the same, no quantity conversion can take place.
■ If the units of measure are different, a conversion can take place either using a quantity conversion type or by simply assigning a unit of measure.
b. If there is no corresponding source key figure of the same type, you have to fill the key figure of the target using a routine.
■ If the unit of measure of the target key figure is fixed, quantity conversion is not performed. This means that if conversion is required, you have to execute it in a routine.
■ If the unit of measure of the target key figure is variable, you also have to assign a variable source unit of measure to the routine. You can use input help to select a unit of measure from the variable units of measure that exist for the target. You have two options:
○ You select a variable unit of measure and assign it.
○ You select a quantity conversion type and a unit of measure into which you wish to convert.
If you have chosen an InfoObject for determining the target unit of measure in the quantity conversion type, you must heed the following when maintaining the transformation rules:
The InfoObject for determining the target unit of measure must be contained in both the source and target systems and must be filled using a rule.
For more information, see Defining Target Units of Measure Using InfoObjects.
If you want to convert units of measure during the transformation but quantity conversion is not available for one of the reasons stated above, you can create a routine. In transformation rule definition, choose Routine with Unit. In the routine editor you get an additional return parameter UNIT and the target unit of measure is determined using the value of this parameter.
For more information, see Routines in Transformations.