Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BottomN function
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.
0
Answers
-
Issue with Topn or Rank , you can find answer here.
0