xtrTimeRollup Value List
Applies To
Discussion
Use the constants of this value list with the TimeStateRollup property of the Measure object to set rollup options for date values.
| Constant |
Description |
|---|---|
| trTimeRollupAverage |
Uses the average of the measure values from all categories in the time period being examined. |
| trTimeRollupCurrentPeriod |
Uses the measure value from the category that is designated 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, where quarter 1 starts in January. The current period is set to April 2000. At the year level, PowerPlay® shows the measure value for April 2000. At the quarter level, it shows the measure value for April in quarter 2 (because April is the current period), but shows the value of the last active month in every other quarter (that is, March for quarter 1; September for quarter 3; December for quarter 4. |
| trTimeRollupEarlyPeriod |
Uses the measure value from the first 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, PowerPlay shows for each quarter the measure value from the first month of each quarter. When you examine data at the Year level, PowerPlay shows the first value from the first month in the first quarter of each year. |
| trTimeRollupLatePeriod |
Uses 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, PowerPlay shows for each quarter the measure value from the last month of each quarter. When you examine data at the Year level, PowerPlay shows the value from the last month in the last quarter of each year. |
| trTimeRollupMaximum |
Uses the largest measure value from all categories in the time period being examined. |
| trTimeRollupMinimum |
Uses the smallest measure value from all categories in the time period being examined. |
| trTimeRollupNone |
Specifies that no time state rollup is performed. Uses the value set for the RegularRollup property instead. |