Dense Rank in OBIEE

Question

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  RankABC                  10                     1XYZ                  20                     2AAA                  20                     2ZZZ                  30                     3DSE                 40                      4

Martin van Donselaar · Answer

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