Home > OLAP Calculation Templates > Period to Date > Period to Date
![]() Previous |
![]() Next |
Calculates the values up to the current time period within an ancestor, such as Quarter or Year, or within a Gregorian level.
{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.
This calculated measure computes the total number of Units from the first time period to the current period within fiscal years.
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.
SUM(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.FISCAL BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL TIME.FISCAL_YEAR)
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