Book Image

SAP BusinessObjects Reporting Cookbook

By : Yoav Yohav
Book Image

SAP BusinessObjects Reporting Cookbook

By: Yoav Yohav

Overview of this book

Table of Contents (21 chapters)
SAP BusinessObjects Reporting Cookbook
About the Author
About the Reviewers

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 the following options:

  • The ranking can be adjusted to Top, Bottom, % Top, % Bottom (that is, from the number of records):

  • The default ranking number is 10, but it can be adjusted to any other number too as it can be changed into a Prompt, as shown:

  • The...