The monthly consolidated cube

The monthly consolidated cube holds the consolidated values for companies defined as groups (or sub-groups) in IBM® Cognos® Controller.

This type of cube is not affected by leaf-level changes in IBM Cognos Controller. This cube will be updated only when a consolidation is run in IBM Cognos Controller.

Figure 1. Tree structure view of the monthly consolidated cube
The tree structure in the monthly consolidated cube shows dimensions that you can select. Attributes in the source are shown as dimensions in the target.

The consolidated cube leverages a variant of the company dimension, CompanyGroup. This is a flat hierarchy containing only the groups and without the period stamp.

By combining data from the detailed and the consolidated cubes (by customizing), it is possible to show the result of the last consolidation on group levels (summation nodes) and latest updates on company level (leaf nodes).