The monthly detailed cube
The monthly detailed cube is the most frequently used cube.
It holds facts and data and comments for all leafs defined in the IBM® Cognos® Controller hierarchy. In addition, summation nodes are automatically calculated by TM1®.
During the consolidation process, when a consolidation is run in IBM Cognos Controller, the result is consolidated values on all groups in the source. In the target cube, the same values can be seen as a result of TM1 aggregating all leaf values into the summation nodes. The consolidated values as such (in the source) are not transferred to the target. However, as soon as a leaf value is updated in the source (IBM Cognos Controller), there is a difference on the group level when comparing the source and the target. This is because each leaf change is propagated to the target and then aggregated according to the aggregation logic in the TM1 OLAP environment. In other words, the summation nodes contain the recent changes in the source. This is different from the source, in which the consolidation values from the last consolidation stay the same, even if a leaf value has been updated.
The next time a consolidation is run in IBM Cognos Controller, the source and the target will look the same again.
