Transformation rules

A number of transformation rules are applied when data is moved from the IBM® Cognos® Controller relational data source to the cube target.

The transformation rules are applied for the following reasons:

There are differences in the way that a relational database and a cube handle data For example, the IBM Cognos Controller relational database stores values on an aggregated level whereas the cube only stores values on a leaf level.
IBM Cognos Controller works with time-dependent dimensions (the company dimension).

When data is changed in IBM Cognos Controller (the source), the service moves the changes to the cube automatically.While moving the data, the service transforms it into pre-defined cube models according to a set of pre-defined rules. This transformation is handled by the FAP Service that is leveraging its own temporary database to complete its job. For a detailed description of the transformation principles, see Dimension transformation principles.