Change: .. AVG(DM.SALES_CUBE.QUANTITY) ................................................. OVER HIERARCHY (DM.TIME.CALENDAR BETWEEN 2 ................................................... PRECEDING AND CURRENT MEMBER WITHIN LEVEL)DM.SALES_CUBE
.. QUANTITY_3_MONTH_MOVING_MAX
MAX(DM.SALES_CUBE.QUANTITY) ................................................. OVER HIERARCHY (DM.TIME.CALENDAR BETWEEN 2 ................................................... PRECEDING AND CURRENT MEMBER WITHIN LEVEL)DM.SALES_CUBE
.. QUANTITY_PR_PERIOD
LAG(DM.SALES_CUBE.QUANTITY, 1) ..................................................OVER HIERARCHY (DM.TIME.CALENDAR)DM.SALES_CUBE
.. QUANTITY_PR_PERIOD_PCT_CHG
LAG_VARIANCE_PERCENT(DM.SALES_CUBE.QUANTITY, 1) ..................................................OVER HIERARCHY (DM.TIME.CALENDAR)
View changes from previous version.
(Word count: 192)