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:
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