If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Running-Total for multiple Measures

Started by clingst, 31 Aug 2015 12:22:38 PM

Previous topic - Next topic

clingst

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.

bdbits

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/
From IBM DeveloperWorks: 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.