Is there a way to create an object that will do the same thing as using Ranking . The reason that i want to do this at the universe object/table level is that i need to appply a break to the ranked object and when i do that it will not get me the proper results. My guess is that ranking works at the table level and whe you apply a break it breaks it into several tables and therefore the count goes off
here is an example of what happens
consultant Jane
id inq number random number ( i have a random id picker object )
1 123
2 234897
3 23434
3 36647
5 2343
8 09873
8 737
12 23432
I can apply a rank to this and get the top 6 per random number
however if i apply a break to the id it will not get the top 3 i get all the data back .
So i was wondering if i could create an object the looks at consultant and picks 6 random ids per consultant
i found a way around it by creating a view in oracle that groups mutiple inquiry numbers to one Id . Didnt learn anything new in BO but got the job done :?