Transformation of Data from External Sources for Open ODS Views

You can use transformations in the BW system for various purposes, for example to perform data type conversions or string operations on data, which is consumed using Open ODS views.

This can be useful for example, if you do not want to or are not able to use these transformations in the data source on data, which is outside of the BW-managed database schema. When defining the Open ODS view, you can therefore use source type Transformation, with a DataSource as the source and an InfoSource as the target. The InfoSource fields are displayed as source fields for the Open ODS view in the Open ODS view maintenance screen. At runtime, the transformation rules set in the transformation are applied on the fields of the DataSource.