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

Filtering the query results

Every query is built to retrieve a specific set of results.

When we define a query, the data can be processed and analyzed in several possible contexts:

  • Time: This gives information about when an event occurred; for example, the sales for the current week (a "when" business question)

  • Data type and specification: This gives the model specifications of the cars that were rented or sold (a "which" business question)

  • Measure: This gives a range or a value that is greater or less than (a "how much" business question)

Without a filtering context, a query is somewhere between serving a meaningless purpose and answering a very general question. The main idea when creating query filters is to fetch only the data that is relevant to the business question. The rule of "garbage in garbage out" applies here. By defining all the relevant conditions, we ensure that we will get accurate results as well as better performance.

Every condition is structured from the following three...