COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cognos_guy on 11 Nov 2010 09:27:03 AM

Title: Olympic ranking not working
Post by: cognos_guy on 11 Nov 2010 09:27:03 AM
I have a simple ranking report.  The report is dense ranking as opposed to olympic ranking.  Does anyone know how to correct this?  Please note that all my other reports (have 100's of them) default to olympic ranking.

Thanks.
Title: Re: Olympic ranking not working
Post by: blom0344 on 11 Nov 2010 09:54:36 AM
The easiest way would be to avoid ties by using an additional field to avoid them, generating unique values to rank against. Is that doable?
Title: Re: Olympic ranking not working
Post by: cognos_guy on 11 Nov 2010 09:58:05 AM
Unfortunately this is not possible because this is a commission report and rank is directly tied to a commission percentage.