Set Regular and Time State Rollup Together

You can use Regular rollup and Time state rollup together to summarize measure values in your OLAP reports. When both are selected, regular rollup is performed first, followed by time-state rollup.

There are several constraints that apply when defining these two types of rollup together:

  • Cognos® Transformer cannot perform Time state rollup for a measure when there is more than one time dimension in the model.
  • You cannot apply summarized views to a time dimension if the model contains a measure with Time state rollup applied.
  • For the time dimension, if you select Average for both Regular and Time state rollup, Cognos Transformer performs Regular rollup first. It then sums the remaining consolidated records and divides by the number of leaf categories in the time period. Lastly, it sums the remaining records and divides by the number of months in the quarter or days in the month.

Procedure

  1. Open the Measure property sheet and click the Rollup tab.
  2. In the Regular rollup box, select a rollup function.

    If you select the Average function, you can weight the average by selecting a measure from the Regular weight box. However, the weighting measure must have a rollup function of Default (Sum) or Sum.

  3. In the Time state rollup box, click a rollup function.

    If you select the Average function, you can weight the average by selecting a measure from the Time state weight box. However, the weighting measure must have a rollup function of Default (Sum) or Sum.

  4. Click OK.