Rolling subtotals coming to OLAP in i7.3

Found this example of new OLAP functions coming to i7.3 DB2. I've been
wanting a way to calculate a rolling subtotal for sometime. This will
eliminate the break point totaling, or extra "grouping sets" I've used in
the past.

http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/sqlp/rbafyolap.htm

Example: Using OLAP Aggregates and CUME_DIST


Suppose that you want to find the rolling sum of the salaries for employees
in department D11 and also the distribution of the salary.


SELECT ROW_NUMBER() OVER() AS ROW, LASTNAME, SALARY,
SUM(SALARY) OVER(ORDER BY SALARY
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS
ROLLING_TOTAL_RANGE,
SUM(SALARY) OVER(ORDER BY SALARY
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS
ROLLING_TOTAL_ROWS,
DECIMAL(CUME_DIST() OVER (ORDER BY SALARY),4,3) AS DISTRIBUTION
FROM EMPLOYEE
WHERE WORKDEPT = 'D11'
ORDER BY SALARY