Print Page - Rank function in Query Join

Title: Rank function in Query Join
Post by: Bonediggler on 03 Jul 2014 02:54:49 PM

Experts -

I am trying to the apply the Rank()function to the result set of a query join. This is not working - the values returned by Rank() appear to be applied to the data before the join somehow.

In any case, how would I get the Rank() function to work in this case?

Thanks in advance for your help!

Title: Re: Rank function in Query Join
Post by: Francis aka khayman on 03 Jul 2014 10:14:45 PM

set it to after auto-aggregation...

more here:

http://cognosm.fm3online.com/relational/top-5-report/

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Bonediggler on 03 Jul 2014 02:54:49 PM