Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: CognosChas15 on 06 Dec 2007 01:14:50 PM

Title: Top n and "ALL Other Report using Report Studio against Cube
Post by: CognosChas15 on 06 Dec 2007 01:14:50 PM
 ???

Is there a way to create Top n Report with "All Other" Column in Report Studio using a Cognos Cube,  we are on version 8.2 of Report Studio and 7.3 of Transformer. 

Thanks

Charlie
Title: Re: Top n and "ALL Other Report using Report Studio against Cube
Post by: rockytopmark on 06 Dec 2007 01:42:02 PM
For the Top N, use the TopCount() function.  Then, in another expression, I'm sure you can return an aggregate of all the members that are NOT IN the TopCount() expression
Title: Re: Top n and "ALL Other Report using Report Studio against Cube
Post by: MFGF on 06 Dec 2007 02:38:14 PM
Hi,

Mark's absolutely correct here.  The other expression he refers to would need to use the _remainderSet() function.

Best regards,

MF.
Title: Re: Top n and "ALL Other Report using Report Studio against Cube
Post by: CognosChas15 on 06 Dec 2007 03:55:40 PM
Thank you both for your Replies,  I had the first part done  Top Count, just did not know how to get the rest... Thanks Again!!!  I will give it a try and let you know the results 

Charlie
Text only | Text with Images