Appreciate if anyone could advice how can I apply the Running-Total function for multiple measures?
I have 2 measures (Count) and (Revenue) by Month (Row) and Year (Column)
Product A Product B
2014 2015 2014 2015
Count | Revenue Count | Revenue Count | Revenue Count | Revenue
Jan 100
Feb 200
YTD 300
Mar 555
YTD 855
I tried with
running-total (currentMeasure for [Month], [Year], [Product Type])
but there is error claims that currentMeasure is not supported for QueryPackage.
In case I interpreted the message wrong, appreciate for your advice how can I apply the running-total correctly for multiple measures.
Thank you.
Unfortunately running-total() only works for relational packages. Yours appears to be dimensional.
For a workaround to get a dimensional equivalent, here are a couple of articles, both using a similar technique.
From one of our sharpest members, CognosPaul: http://cognospaul.com/2010/10/27/running-total-on-a-cube/ (http://cognospaul.com/2010/10/27/running-total-on-a-cube/)
From IBM DeveloperWorks: http://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page563.html (http://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page563.html)
The links are from a while back but the technique still looks to me like it would be valid.