BW BI Transformation Creating Transformations

Procedure

You are in the Modeling functional area of the Data Warehousing Workbench.

Choose Save.

1. In the InfoProvider tree, choose Create Transformationin the context menu for your InfoProvider.

2. Select a source for your transformation and choose Create Transformation.

3. The system proposes a transformation. You can use this transformation as it is, or modify it to suit your requirements. To the left of the screen, you see the source; to the right of the screen, you see the rule group. To show the target as well, choose Switch Detail View On/Off.

For InfoCubes with non-cumulative key figures, you cannot change the transformation suggested by the system. These transformation rules fill the time reference characteristic of the InfoCube. All other time characteristics are automatically derived from the time-reference characteristic.

4. Using the mouse, you can create new connecting arrows or change existing connecting arrows; you can delete a connecting arrow by choosing the relevant entry in the context menu for the arrow.

5. You can activate the check for referential integrity in the rule group for single characteristics.

The check for referential integrity determines the valid values of the characteristic. It is checked against the master data table (meaning the SID table) or against a DataStore object that is specified in the InfoObject maintenance for this characteristic.

6. If you double-click an InfoObject in the transformation group, the maintenance screen for the rule details is displayed. You can also

○ Select a rule type.

More information: Rule Type

○ Activate the conversion routine, if it exists. It is deactivated by default because the system assumes that the DataSource provides the internal format.

More information: Conversion Routines in BI Systems.

○ With key figures, you can specify a transformation type and define a currency translation or quantity conversion. More information:

■ Currency Translation During Transformation

■ Quantity Conversion During Transformation

○ Using the InfoObject Assignment field for a source field, you can assign an InfoObject to a DataSource from which the data is to be read. This is required to read master data and for currency translations and quantity conversions. More information:

■ Assigning InfoObjects for Reading Master Data

■ Assigning InfoObjects for Converting Amounts or Currencies

■ Assigning InfoObjects for Time Conversion

○ With Test Rule, you can check whether source values are updated to the target (for example, for analyzing errors in complex routines).
See also: Testing Rules

7. To create additional rule groups, choose Rule Group ® New Rule Group.

8. To create the corresponding routines for your transformation, choose Start Routine and End Routine.

See also: Routines in Transformations

9. With Extras