BusinessObjects Board

Ranking at the universe level

building semantic layer
#1

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

honkeyhindu (BOB member since 2007-03-29)

#2

can you post here your formula and expected results?
I guess you have to play with reset_dimensions parameter of Rank function

Dmitry Biryukov :switzerland: (BOB member since 2006-10-15)

#3

Read this recent post discussing ranking based on prompt

.

haider :es: (BOB member since 2005-07-18)

#4

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 :?

honkeyhindu (BOB member since 2007-03-29)