Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

WEBI Database ranking problem

Hi,

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.

Eg:

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.

Thanks

Sudhir.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question