IBM Cognos User Manual

Note: When you enable consolidation on the General tab of the PowerCube
property sheet, Cognos Transformer performs the duplicates rollup first, followed
by the regular rollup.
Regular Rollup
The following table lists the regular rollup options and explains how the results
appear in the reporting components.
Regular rollup option Results in reporting component
Sum Shows the sum of the values of all
descendant categories of the current
category.
Minimum Shows the minimum data value among all
descendant categories of the current
category.
Maximum Shows the maximum data value among all
descendant categories of the current
category.
Average Shows the average of the values of all
records of descendant categories of the
current category.
Count Shows the number of records that contain
non-null values in all descendant categories
of the current category.
Count All Shows the number of records, including
those containing null values for this
measure, for all descendant categories of the
current category.
Any Shows the value 1 if any records for a
descendant category contain values. Shows
the value 0 if no records exist for this
measure or all records that do exist have
null values for this measure.
External Shows source values that were directly
assigned to specific data records.
Time State Rollup
The following table lists the time state rollup options and explains how the results
appear in the reporting components.
Time state rollup
option Results in reporting component
None (regular
rollup)
Shows rollups not associated with a time state measure. Use when the
measure is not a time state measure.
Minimum Shows the smallest measure value from all categories in the time
period being examined.
Maximum Shows the largest measure value from all categories in the time period
being examined.
332 IBM Cognos Transformer Version 10.1.1: User Guide

IBM Cognos Specifications

General

Brand	IBM
Model	Cognos
Category	Transformer
Language	English