Skip to content

Oracle Communities

Register to the Data Intelligence Summit Mexico Register today to the Oracle Analytics Data Intelligence Summit in Mexico on April 8th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dense Rank in OBIEE

Received Response

171

Views

1

Comments

DollyG

DollyG Rank 5 - Community Champion

November 2017 edited August 2024 in Oracle Analytics Cloud and Server

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

0

Answers

Martin van Donselaar Rank 6 - Analytics Lead

November 2017

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

0