Skip Headers
Previous
Previous
 
Next
Next

Percent Difference from Period To Date Period Ago

Calculates the percent difference in values aggregated to the current time period compared to the same calculation up to an earlier period.

Template

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

Example

This calculated measure superimposes the Gregorian year on the Fiscal hierarchy to define the range of time periods included in the calculation. It computes the percent difference between the running totals for the current period and for the previous period within a Gregorian year. The running totals start with the last period in the Gregorian year.

Calculation

Percent difference between the current Gregorian Year to date and Gregorian year to date 1 period ago for UNITS (...) in the TIME dimension and TIME.FISCAL hierarchy. Aggregate using SUM from the end of the period.

OLAP Expression Syntax

LAG_VARIANCE_PERCENT(SUM(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.FISCAL BETWEEN CURRENT MEMBER AND UNBOUNDED FOLLOWING WITHIN GREGORIAN YEAR),1) OVER HIERARCHY (TIME.FISCAL)

Query Results

The Pct Diff column shows the percent difference in Units sold to date between the current period and the previous period. The calculations are performed over Gregorian years, so that Q3 FY-04 to Q2-FY05 are calculated together for Gregorian year 2004, and Q3 FY-05 to Q2 FY-06 for 2005. In this example, the values are totalled from the end of the Gregorian year. The Gregorian years do not contain the fiscal years, so they are not included in the calculations.

Time      Ending       Units To Date Period Ago    Diff Pct Diff
--------- ---------- ------- ------- ---------- ------- --------
Q1 FY-04   30-SEP-03  140931  286647     423965 -137318     -.32
Q2 FY-04   31-DEC-03  145716  145716     286647 -140931     -.49
Q3 FY-04   31-MAR-04  146529  587419     145716  441703     3.03
Q4 FY-04   30-JUN-04  143070  440890     587419 -146529     -.25
Q1 FY-05   30-SEP-04  148292  297820     440890 -143070     -.32
Q2 FY-05   31-DEC-04  149528  149528     297820 -148292     -.5
Q3 FY-05   31-MAR-05  143607  565718     149528  416190     2.78
Q4 FY-05   30-JUN-05  138096  422111     565718 -143607     -.25
Q1 FY-06   30-SEP-05  138953  284015     422111 -138096     -.33
Q2 FY-06   31-DEC-05  145062  145062     284015 -138953     -.49
Q3 FY-06   31-MAR-06  146819  584929     145062  439867     3.03
Q4 FY-06   30-JUN-06  145233  438110     584929 -146819     -.25
FY2004     30-JUN-04  576246    null       null    null     null
FY2005     30-JUN-05  579523    null       null    null     null
FY2006     30-JUN-06  576067    null       null    null     null