How to dense rank the data in OBIEE 11G?

Question

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.

#Mayur · Answer

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.

User472204-OC · Answer

Is it possibile to do it?