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 ...

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.