How to get top 5 model report in Obiee

User_HQ9TE

Hello Everyone,

I have a 2 columns 1 is model and another is measure column so how to set top 5 model report in Obiee

Could you please guide me any one

Thanks

Federico Venturin

Hi @User_HQ9TE ,

Please refer to this blog post: https://blogs.oracle.com/analytics/post/how-to-calculate-top-n-versus-rest-of-population-in-oracle-analytics

It's about DV, but you can use the same syntax in OBIEE (Classic Analytics) as well.

EzequielC-Oracle

Hi @User_HQ9TE

Please, look at the following 2 videos for different ways of showing top members:

Top N Filter on Attribute Columns:

https://www.youtube.com/watch?v=DdrBT72hOjU

Calculate and Visualize Top N Values vs Rest of all Members:

https://www.youtube.com/watch?v=HNrOLmEHgpQ

Regards,

Ezequiel.