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.
Is it possibile to do it?
There is function for "dense rank" in oracle SQL you can try this with the Evaluate function.
Try this, I guess it will work.