Dimension transformation principles

To understand the FAP cubes and how to author reports based on data in the cubes, it is important to understand the underlying transformation principles.

The Account dimension
The account structure in IBM Cognos Controller's relational source allows a base account to logically sum-up several times to the same summation account, as illustrated in the example.
The Company dimension
The company structure is period dependent in the source, one structure version per month. IBM Cognos Controller Financial Analytics Publisher can handle multiple company structures for different consolidation types and periods. This allows you to drill down through the group and company tree for other periods.
The CompanyGroup dimension
The CompanyGroup dimension contains all groups in a flat hierarchy and without period stamps. This dimension is used in the consolidated cube only.
Extended dimensions 1-4
Extended dimensions are dimensions that are defined by users. When IBM Cognos Financial Analysis Publisher transforms extended dimensions 1-4, the dimension names that are used in the source relational database are also used in the cube.
The ActualityMonthly dimension
The actualitymonthly dimension is a list of the used actualities without any hierarchical logic. The actuality is transformed as it is logically used in the relational source.
Linked actualities
Linked actualities are also moved to the ActualityMonthly dimension.
The ActualityWeekly dimension
The ActualityWeekly dimension is, in the same way as the ActualityMonthly dimension, a list of actualities without any hierarchical logic. The actuality is transformed as it is logically used in the relational source. However, only source actualities defined as weekly are included in this dimension, and they are used in the weekly cube only.
The PeriodMonthly dimension
Similar to actualitymonthly dimension, periodmonthly is a separate dimension and is aggregated from months into quarters and then into years. The periodmonthly dimension's year and quarter levels are not explicitly present in the source. The period hierarchy is not meant for aggregation; its purpose is to support relative period logic and to support relative periods in the year following the financial year, and not the calendar year.
The PeriodWeekly dimension
The PeriodWeekly dimension is similar to PeriodMonthly, however, it is aggregated from weeks into years. It is used in the weekly cube.
The Currency dimension
The currency dimension is transformed in a straightforward 1:1 fashion, that is, the target looks the same as the source.
The Transaction currency dimension
The transaction currency dimension is transformed in a straightforward 1:1 fashion, that is, the target looks the same as the source.
Consolidation perspective
The transformation principle for the consolidation perspective is straightforward. Reported values and manual journals (ktypkonc is blank) get no consolidation perspective. Other records, that is, automatic journals get the consolidation perspective as the consolidation type, for example, LE and CT_LE are an aggregated node.
Closing versions
The manual journal types with the closing version aggregation level in the source are called closing versions in the target, and have a 1:1 transformation rule.
Contribution versions
The contribution versions in the target are prefixed with CO. Automatic journal types have the same code as in the source with one exception; the base value automatic journal type which is displayed as BASEET because ' ' is not a valid name in the target. You can configure the naming convention in the FAP client.
The Origin company dimension
The origin company dimension (source company) contains all companies in the source as members in a simple structure.
The Counter company dimension
The counter company dimension (source company) contains all companies in the source as members in a simple structure.
The Journal number dimension
The journal number dimension is transformed 1:1, that is, the target looks the same as the source.
The Counter dimension
The counter dimension is a duplicate of the external dimension 1, and uses the same transformation principle.
The Measurement dimension
In the cube there is a measurement dimension, which corresponds to the two value columns in the fact table; amount and transamount. In the target this dimension will have three members, with the option to add more in the future.

Parent topic: How IBM Cognos Controller data is transformed into a reporting format