Rank Function

[Bonediggler]

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!

[MFGF]

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.

[Bonediggler]

Even easier - thanks MF!