Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

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

172

Views

1

Comments

DollyG

DollyG Rank 5 - Community Champion

Nov 14, 2017 4:53AM edited Aug 13, 2024 5:55PM 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

Nov 14, 2017 5:48AM

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