Oracle^® Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide > Basics of Working with Requests in Oracle BI Answers >

Combining Oracle BI Request Criteria Using Set Operations

After you have selected a subject area and added columns to a request, you can combine criteria from one or more subject areas using Set operations. This action combines the results of two or more requests into a single result.

NOTE:  The number and data types of the columns selected in each component request must be the same. The column lengths can differ.

The following table lists the Set operators and describes their effects on results.

To combine the results of multiple Oracle BI requests

1. Select a subject area and add columns to the request at the Criteria tab in Oracle BI Answers.
2. At the Criteria tab, click the following button:

   Combine with Similar Request

   The Subject Area dialog box appears.

3. Select a subject area that contains the data you want to combine with the selections you made in Step 1.

   The subject area can be the same as that selected in Step 1, or a different subject area.

   The Set Operations page appears.

4. Follow the on-screen instructions to construct the combined request.
5. Click the Union button and select the operation type, and select columns from the selection pane to combine with the first request.