WEBI Database ranking problem
I have a problem with Add Database ranking feature in query filter in WEBI rich client.
I have 100 products and would like to pull only top 10 products onto my report based on number of sales (measure). I am using SQL server 2008. But when I use this feature I am only getting a table with only top 4 products in my report. When I increase the number to sat 50 or 60 (top 50 products in my query) I am getting top 10 now.
Is it a bug which can be fixed with any fix pack. Like I get only top 4 products if I choose top 10 in the ADD database ranking and I get 10 if I use any number greater than 63 in the query.
Case1: Query: Database ranking : Top 10; Product (Dimension); based on Sales(measure)\
Result: Table with only top 4 products sorted in descending order instead of 10 products
Case2: Query: Database ranking : Top 63; Product (Dimension); based on Sales(measure)\
Result: Table with only top 10 products sorted in descending order.
Right now it meets my criteria of getting top 10 products when I use top 63 in the query, but I think there is something wrong with this work around. Please reply me with any solution.