Skip Headers
Previous
Previous
 
Next
Next

Cumulative Total

Calculates a running total across a range of consecutive time periods.

Template

Cumulative total (sum) of measure (...) in the time dimension and time hierarchy within { level | parent | ancestor at level level | }. Total from { beginning to current | current to following | beginning to following } member.

Example

This calculated measure computes the total number of Units from the first time period in the year to the current time period.

Calculation

Cumulative total (sum) of UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy within ancestor at level TIME.CALENDAR_YEAR. Total from beginning to current member.

OLAP Expression Syntax

SUM(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.CALENDAR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL TIME.CALENDAR_YEAR)

Query Results

The Total column shows the total number of Units from the first quarter in the year to the current quarter. At the Calendar Year level, 2005 and 2006 are the only periods within their respective ranges.

Time   Level                  Units   Total
------ ------------------- -------- -------
Q1.05  CALENDAR_QUARTER      143607  143607
Q2.05  CALENDAR_QUARTER      138096  281703
Q3.05  CALENDAR_QUARTER      138953  420656
Q4.05  CALENDAR_QUARTER      145062  565718
Q1.06  CALENDAR_QUARTER      146819  146819
Q2.06  CALENDAR_QUARTER      145233  292052
Q3.06  CALENDAR_QUARTER      143572  435624
Q4.06  CALENDAR_QUARTER      149305  584929
2005   CALENDAR_YEAR         565718  565718
2006   CALENDAR_YEAR         584929  584929