Skip Headers
Previous
Previous
 
Next
Next

Period to Date

Calculates the values up to the current time period within an ancestor, such as Quarter or Year, or within a Gregorian level.

Template

{Gregorian level | ancestor at level level } to date for measure (...) in the time dimension and time hierarchy hierarchy. Aggregate using { SUM | MAXIMUM | MINIMUM | AVERAGE } from the { beginning | end } of the period.

Example

This calculated measure computes the total number of Units from the first time period to the current period within fiscal years.

Calculation

Ancestor at level TIME.FISCAL_YEAR to date for UNITS(...) in the TIME dimension and TIME.FISCAL hierarchy. Aggregate using SUM from the beginning of the period.

OLAP Expression Syntax

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

Query Results

The To Date column shows a running total calculated within fiscal years. Q1 FY-05 to Q4 FY-05 are calculated together, and Q1 FY-06 to Q4 FY-06 are calculated together. At the Fiscal Year level, FY2005 and FY2006 are the only periods within their respective fiscal years.

Time      Parent    Units To Date
--------- -------- ------ -------
Q1 FY-05  FY2005   148292  148292
Q2 FY-05  FY2005   149528  297820
Q3 FY-05  FY2005   143607  441427
Q4 FY-05  FY2005   138096  579523
Q1 FY-06  FY2006   138953  138953
Q2 FY-06  FY2006   145062  284015
Q3 FY-06  FY2006   146819  430834
Q4 FY-06  FY2006   145233  576067
FY2005    TOTAL    579523  579523
FY2006    TOTAL    576067  576067