Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mickyo73 on 27 Oct 2014 04:26:55 AM

Title: Running/Cumulative Balance in report Studio using OLAP source
Post by: mickyo73 on 27 Oct 2014 04:26:55 AM
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
Title: Re: Running/Cumulative Balance in report Studio using OLAP source
Post by: CognosAnalytics on 28 Oct 2014 07:07:36 PM
Hello Mickyo,
Try this...
http://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page563.html

Text only | Text with Images