Transformation

Use:  The transformation process allows you to consolidate, cleanse, and integrate data. You can semantically synchronize data from heterogeneous sources.

When you load data from one BI object into a further BI object, the data is passed through a transformation. A transformation converts the fields of the source into the format of the target.

SAP Netweaver BW has multiple transformation options for the consolidation of data acquired from a wide variety of sources in different formats:

• Direct Assignment - It is 1:1 transformations, this is used when source data is moved to target without any changes.

• Constant - This is used when source doesn't give a value for a specific field, and you want to supply a constant value for that filed.

• Formula - This is used when target value is derived using a formula. ex: value = price X quantity.

• Initial - This is used if you aren't interested in supplying values for a field . Numerical values will be populated with zero, and character fields will be populated with a blank space.

• Read Master Data - Consider a target with 2 fields... MATERIAL and COLOR OF MATERIAL, assume that source data has a value for only MATERIAL field. But we have data for COLOR OF MATERIAL in master data of that MATERIAL.. In this scenario , we can use read master data type of transformation. and COLOR OF MATERIAL will read from master data.

• Read from DSO - This is similar to Read Master Data, but data is read from the DSO. (this not available in BI 7.0,available from 7.3)

• Routine - This type of transformation is an ABAP code based transformation.
• No Transformation: No need to map target info object.

 Constant:

 

Direct Assignment:

ABAP routine:

 Formula:

 Initial:

 Read Master Data:

Rule Type for Characteristic:

Rule Type for Keyfigure: