The rollup functions specify how measure values are evaluated in the reporting components. There are three rollup types:
Regular Rollup
Measure values are summarized from lower to higher category levels. Transformer applies these functions when the cube is created. The reporting components apply them at run time.
Time State Rollup
Transformer represents the state of a measure at specific times.
For example, if a model tracks the number of active customers at the end of each quarter, you can set up a time state measure to report the number of customers active at a specific time. This is more useful than the quarterly sum of the number of customers served during each month in a quarter.
Duplicates Rollup
Transformer evaluates duplicate records in the source data.
When you enable consolidation on the General tab of the PowerCube property sheet, Transformer performs the duplicates rollup first, followed by the 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. |
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. |
| First Period | Shows the measure value from the first subordinate period in the time period being examined. For example, a time dimension contains years, quarters, and months, and you are examining data at the quarter level. For each quarter, the First Period option reports the measure value from the first month of the quarter. When you examine data at the year level, the option reports the first value from the first month in the first quarter of each year. |
| Last Period | Shows the measure value from the last subordinate period in the time period being examined. For example, if a time dimension contains years, quarters, and months, and you are examining data at the quarter level, for each quarter, the Last Period option reports the measure value from the last month of each quarter. When you examine data at the year level, reports the value from the last month in the last quarter of each year. |
| Current Period | Shows the measure value from the category that is designated as the current period in the time dimension. If the time period being examined does not include the current period, the result is identical to Last Period. For example, a time dimension contains years, quarters, and months, and Quarter 1 starts in January. The current period is set to April 2007. At the year level, the Current Period option reports the measure value for April 2007. At the quarter level, the option reports the measure value for April in Quarter 2 because April is the current period, but it shows the value of the last active month in every other quarter; that is, March for Quarter 1, September for Quarter 3, and December for Quarter 4. |
| Average | Shows the average of the measure values from all categories in the time period being examined. |
The following table lists the available duplicates rollup options and explains how the results appear in the reporting components.
| Duplicates rollup option | Results in reporting component |
| None (regular rollup) | Uses the Regular Rollup function specified for the measure. |
| Sum | Sums the measure values found in the duplicate records, except for external rollups, which override this function. |
| Minimum | Takes the smallest of all values for the measure found in the duplicate records. |
| Maximum | Takes the largest of all values for the measure found in the duplicate records. |
| Average | Takes the average of all values for the measure found in the duplicate records. If the Regular Rollup option is also set to Average, duplicates rollup is performed before regular rollup. |
| First | Takes the first value of all values for the measure found in the duplicate records by using the order of the records in the data source. |
| Last | Takes the last value of all values for the measure found in the duplicate records by using the order of the records in the data source. |
A Duplicates Rollup setting other than None forces Transformer to consolidate the source file when generating cubes, as described in the following table.
| Consolidation setting | Transformer action |
| Default or Yes (with sort) | Sorts the source file, then consolidates duplicate records by using the Duplicates Rollup function. |
| No | Overrides the Consolidation setting,
sorts the source file, and does not consolidate duplicate records. The duplicate rollup rule is ignored. |
| Yes (presort) | Consolidates the source data by using the Duplicates Rollup function without first sorting the source file. |