Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cognos.cognosbi@gmail.com on 09 Sep 2011 09:27:04 AM

Title: Display top Revenue in Report Studio
Post by: cognos.cognosbi@gmail.com on 09 Sep 2011 09:27:04 AM
Hi All,

I know that to find top 5 or any Revenue in cognos report studio we have a function called TopCount() (or) write a Query in Report Studio.Please anyone suggest other solution except these 2 to find top values.

Thanks And Regards
cool cognos.
Title: Re: Display top Revenue in Report Studio
Post by: MFGF on 09 Sep 2011 10:57:42 AM
TopCount() is a dimensional function for use with OLAP and DMR packages.  For a relational package, you might try adding a rank calculation, sorting on this, then filtering it to return values less than or equal to 5.

Regards,

MF.
Text only | Text with Images