Print Page - Help with Rank Function

Title: Help with Rank Function
Post by: rajua99 on 04 Jun 2013 12:16:16 AM

Hello,

I have a Graph in my report and the default measure on that query is # of projects and the Y Axis is the Project manager.

My requirement is to show how many projects each project manager has in the form of Graph.

Now they want to display only top 10 project managers who got highest number of projects.

I am having difficulty on how to apply Rank Function on the Query to display top 10 Project managers in the Graph.

Can you help me on how to apply rank function on that Query..

Thanks in advance,
Raju

Title: Re: Help with Rank Function
Post by: Ganesh Kedari on 04 Jun 2013 12:37:26 AM

Hi
You can refer http://cognosgeek.wordpress.com/2012/11/08/show-top-10-values-in-cognos-report-studio-chart/
Let me know if you get any issues while applying this.

Title: Re: Help with Rank Function
Post by: Satheesh on 04 Jun 2013 12:55:38 AM

you can use a filter in Query like
rank(<your measure>) <= 10

I think Series is not required
X-axis is Managers list
Measure is - No.of Projects data item

this will show only top 10 PM's
Sort the X-axis by using rank data Item{ rank(<measure_no.of projects>) }

Regards
Sateesh

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rajua99 on 04 Jun 2013 12:16:16 AM