Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 06, 2011 at 05:50 PM

    Did you try to run the SQL statement generated by your WebI report directly against the database?

    How many rows do you get back?

    What kind of data source do you access?

    Regards,

    Stratos

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Still unable to resolve this issue.

      Can I create a Object in Universe such that when I use in my WEBI I get only top Ten Applications based on Active Time. Also the Top ten should change with the prompts at WEBI query level.

      For Example:

      Prompt on Time period when given should pull top ten application for that particular period of time only.

      Can anybody send me a example of the syntax of the SQL for creating an object.

      Another question is can I not use Dimension object from one table and measure object from another table where both the tables at joined at Universe level ?

      Should I create a Derived table fro resolving this?

      Thanks,

      Sudhir.

  • avatar image
    Former Member
    Apr 06, 2011 at 06:18 PM

    Looks like this is an issue with Dimension associated with ranking. Try add ranking from the Alert button in the tool bar. Also try Ranking in other reports to check whether its an issue with SP or FP.

    Thanks,

    Rajesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I just figured out that the approach is not working. For example

      Case1: Using Application for Ranking and User with Rank variable and filter.

      once I rank the based on the Application then add the Rank_User variable to the filter pane, the set of top ten applications is changing. This mean that the top 10 Applications pulled using Ranking is not working as it changing based on the Ran_user filter variable.

      My requirement is to limit the number of users to top ten for the given set of top 10 applications. But when the list of top 10 applications changes the results are effected.

      same issue with Case 2: Using Top 10 Users and creating a rank variable for application and using it in filter pane.

      Coming back to Database ranking did anyone figure out whether this is an known issue with error due to Database connections or solved by Fix packs.

      Thanks

      Sudhir.