Transformation Properties

Posted by on



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.

  • Routine - This type of transformation is an ABAP code based transformation .





Now lets check the transformation options for keyfigures...







lets select formula option




















We had done a formula transformation now...




Comments

Post a Comment