Skip to Content
0
Former Member
Apr 23, 2009 at 09:13 AM

Top 'n' using rank () function

2175 Views

Hi...

I'm using BO XI 3.0. In my report I need a user to enter TOP 'n' (n=5,10,20,50,100).

For example:

Caller No No of Calls

23467891 10

67698089 35

22377868 17

76378467 10

76374678 20

89978978 6

87786777 11

I already create dimension object for Caller No and measure object for No of Calls in universe.

So I use a rank filter in edit query but it doesn't work.

I also create another measure object in universe name =ranking

rank(No_of_Calls) over(partition by (Caller No) order by (No_of_Calls)).. but it's not work...

So can anybody help me....thanks