Running/Cumulative Balance in report Studio using OLAP source

[mickyo73]

Hi All,

I have a scenario where I have a crosstab with nested member sets on the rows from 2 different dimensions (SSAS is the data source) and a measure on the columns. I need to try and get a running balance in the column next to the measure as a second measure.

eg

Col 1        Col 2      Value      Running/Cumulative Total
1/7/07      CR          -30         -30
15/7/07    IN           100        70
25/7/07    CR          -15         55
                IN            200        255

All the examples I've found show how to create the running balance with members from only 1 dimension on the rows. I haven't been able to crack the trick to get the running/cumulative balance using 2 nested dimensions from the cube.

Any ideas would be appreciated.

Thanks
Mick

[cognos810]

Hello Mickyo,
Try this...
http://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page563.html