How to dense rank the data in OBIEE 11G? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to dense rank the data in OBIEE 11G?

Received Response
11
Views
2
Comments
User472204-OC
User472204-OC Rank 5 - Community Champion
edited Aug 13, 2024 6:59PM in Oracle Analytics Cloud and Server


In OBIEE 11G, how to use rank for implement the following requirement in analytics? Thanks.

PS: I do not find the "dense rank" function in formula in analytics. Is there other functions or other idea to implement this requirement? Thanks.

Rank_Data.JPGRank_An.JPG

Answers

  • User472204-OC
    User472204-OC Rank 5 - Community Champion


    Is it possibile to do it?

  • #Mayur
    #Mayur Rank 5 - Community Champion

    HI,

    There is function for "dense rank" in oracle SQL you can try this with the Evaluate function.

    Try this, I guess it will work.

    Thank You.