Creating a Calculated Measure: This screen capture shows the General tab of the Create Calculated Measure dialog box. The following values are shown:

• Name: UNITS_PP

• Short Label: Units Pp

• Long Label: Units Prior Period

• Description: Units Prior Period

• Calculation type: Prior Period

• Calculation: Period period for measure UNITS in TIME dimension and TIME.CALENDAR hierarchy 1 period ago

• Expression: LAG(UNITS_CUBE.UNITS, 1) OVER HIERARCHY(TIME.CALENDAR)