Using database ranking
Database ranking is an advanced query filter that can rank the query results according to a measure.
Ranking is good for classical business questions such as the following:
- Who are the top n customers by revenue?
- What are the top n most sold products?
- Which sales people had the least n sales?
Getting ready
We want to rank the top five best salespeople based on their sales revenue.
How to do it...
First, we will build our query by dragging-and-dropping the Sales Person and Sales Revenue objects. We will mark the Sales Person dimension objects and click on the Add a database ranking button located on the query filter's top right-hand side, as shown in the following screenshot:
In the database ranking created filter, we will notice ...
Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
