Click Run Query. The queries within a combined query must return the same number of objects of the same data type and the objects must be in the same order. You cannot combine queries when the number of objects in the query results and the data types of those objects are not identical.

The merge function in BusinessObjects makes it possible to create a report that displays query results from multiple data sets. You can merge: All of the queries must have at least one dimension object in common, for example, EmplID or DeptID. For background information, see Overview: Merging Data from Multiple Queries.

A combined query is a group of queries that work together to return a single result. Note You can only use the combined query feature with relational universes. A UNION query takes all the data from both queries, eliminates duplicate rows, and builds a combined data set. An INTERSECTION query returns the data that is common to both queries.

You can merge: You might merge multiple queries in a single universe in order to: Display all values of a certain field in a crosstab, including blank rows. Display data in a single row rather than multiple rows. Retrieve data from a single universe for two different levels of detail, time periods, or populations.