Adding another query

Building several queries in the Query Panel is a core functionality of Web Intelligence.

The ability to centralize several data aspects in the same report is considered in many ways the heart of reporting and analysis.

There are many scenarios where we would be required to build more than one query; the main reasons are presented as follows:

• The report needs to present different queries with different filters that can't be unified into one query (will create contradiction in the filters)

• There are also several contexts in the universe that require separation between the queries

  Note

  Contexts are structures that can be created in universes when a business question can be asked in several different contexts. For example, in the Motors universe, we can analyze the customer data in the sales context (who bought a car) and we can analyze the customer data in the rental context (which customer rented a car).

  Contexts are also created when there are data areas in the universe that...