COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: mycognos on 22 Apr 2009 08:20:40 AM

Title: Incorrect subtotals in Analysis Studio
Post by: mycognos on 22 Apr 2009 08:20:40 AM
Hi,

I have some calculated measures in my transformer and when I analyze the data using analysis studio, the subtotals for these calculated measures are coming incorrectly, but for direct measures the subtotal is working fine. I have used after rollup in all those mesures. Can anyone help me to find out the issue???
Title: Re: Incorrect subtotals in Analysis Studio
Post by: timkline on 11 May 2009 01:02:00 PM
I have had many issues with sub-totals and have dealt with Cognos support on this.  Sometimes sub-totals don't correctly sum when using filters.  My most recent response from Cognos support regarding a sub-total issue was the following.  I would recommend you contact Cognos about the issue or you could end wasting a lot of time on something that doesn't work correctly.


I have logged bug 624364 for this issue. The results SHOULD recalculate when filters are added to the analysis. If this bug gets rejected as design intent, I will be provided with a reason and a way for you to accomplish what you are attempting. I will now proceed to park your case against this bug.
Title: Re: Incorrect subtotals in Analysis Studio
Post by: vinay17in on 18 May 2009 11:45:38 PM
Guys, can you provide the specific examples of the calculated measures or what you are trying to accomplish.