Dense Rank in OBIEE

DollyG

Hi,

Can anyone please help me in applying dense rank in obiee?

I need to get data of top 3 dense ranks, so the result should display 4 rows in this case as rank 2 is shared by 2 products.

For example, my table structure is:

Products        Sales                Dense  Rank
ABC                  10                     1
XYZ                  20                     2
AAA                  20                     2
ZZZ                  30                     3
DSE                 40                      4

Martin van Donselaar

You'll have to use the evaluate function for that.

I think this link describes it quite well: ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION 100: Rank and Dense Rank Functions:OBIEE