Chapter 2. Creating New Queries

In this chapter, we will cover the following recipes:

  • The universe structure
  • Creating a simple query
  • Editing the query
  • Filtering the query results
  • Using prompts
  • Using AND/OR logic in conditions
  • Creating nested filters
  • Using a subquery
  • Using combined queries
  • Adding another query
  • Working with several queries
  • Working with the query properties
  • Using the data preview
  • Viewing the SQL
  • Using other query results
  • Scope of analysis
  • Using database ranking
  • Using BEx queries

Introduction

Creating queries is considered in many ways the core functionality of the Web Intelligence application. The source for every report is a query that is based on a database (relational or operational), a data warehouse, an OLAP cube, a BEx query, a web service, or ...

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.