The weekly cube

The weekly cube is only applicable to IBM® Cognos® Controller installations where weekly actualities have been configured.

This cube is similar to the monthly cube but with two main differences:

  • It uses the ActualityWeekly (instead of the ActualityMonthly) dimension.
  • It uses the PeriodWeekly (instead of the PeriodMonthly) dimension.

Please note that the hierarchy for the PeriodWeekly dimension is Year->Week; that is, month is not part of the hierarchy. This is because IBM Cognos Controller does not handle the relationship between months and weeks, that is, determining what weeks, or parts of weeks, go into a certain month.

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