Experts -
I need to rank values in a set based on two fields. I.e. rank dollars paid per institution per region. I believe this equates to Oracle's Dense_Rank() function - something like:
Dense_Rank() over (partition by institution, region order by salary) AS Rank
How to do this in Cognos? I cannot seem to get the "Vendor Specific" functions to work. Cognos is sitting on an Oracle back-end.
Thanks in advance!
Quote from: Bonediggler on 01 Aug 2014 09:33:40 AM
Experts -
I need to rank values in a set based on two fields. I.e. rank dollars paid per institution per region. I believe this equates to Oracle's Dense_Rank() function - something like:
Dense_Rank() over (partition by institution, region order by salary) AS Rank
How to do this in Cognos? I cannot seem to get the "Vendor Specific" functions to work. Cognos is sitting on an Oracle back-end.
Thanks in advance!
How about a query calculation with the expression:
rank([salary] for [institution], [region])
Cheers!
MF.
Even easier - thanks MF!