BottomN function — Oracle Analytics

Oracle Analytics Cloud and Server

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

BottomN function

Received Response
1
Views
1
Comments
3355141
3355141 Rank 2 - Community Beginner

I'm trying to show the worst 50 records based on Premium since I'm making a dashboard for an insurance company. I'm using union since that's a necessity in order to fulfill my requirement. The resulting reports shows more than 50 records i.e 60 records to be exact. It marks the same bottom position (a numeric value) to multiple records due to which it shows more than 50 records. Please let me know how to get rid off this problem. I'm using OBIEE 11g.

Answers