| Print Open PDF Version of Online Help

#### Combining Analyses Using Set Operations A combined analysis is an analysis that combines the results of multiple criteria into a single analysis by querying two or more subject areas to generate a new result. By using this technique, you can combine these criteria allowing you to simulate joins that otherwise do not exist. Each column from a combined analysis contains the results of multiple queries against the subject areas. Each criterion in a combined analysis can be created using the same or different subject areas. By using set operators, you can define how the data sets generated by each criterion are related to one another. NOTE: The number of columns from each subject area must be the same, and the data types of the columns that you want to combine must be the same. The column lengths can differ. The following table lists the Set operators and describes their effects on results.
Set Operator | Effect on Results
--- | ---
Union | Returns nonduplicate rows from all columns.
Union All | Returns all rows from all columns, including duplicate rows.
Intersect | Returns rows that are common to all columns.
Minus | Returns rows from the first column that are not in the other columns.
To combine analyses In the Criteria tab of the analysis editor, add the columns that you want to include in the analysis. In the Selected Columns pane, click the "Combine results based on union, intersection, and difference operations" icon. In the Subject Area dialog box, select a subject area that contains the data that you want to combine with the columns in your analysis. The subject area can be the same as the subject area from which the existing columns in the report are taken or a different subject area. The Set Operations page appears. From the Subject Areas pane, add the columns that you want to combine with the columns you have already selected for the analysis. Click the Union icon and select the operation type. (Optional) To change the heading or edit other properties of the combined column, do the following: Click the Result Columns link. In the drop-down list of options for the column, select Column Properties. Click the Results tab to view the columns in a table in the compound layout for the analysis. More information about combining analyses is available on My Oracle Support, as follows: For general information about combining analyses, see Doc ID 2319063.1. For information about when you might want to create a combined analysis, see Doc ID 2319069.1. For information about how to create a combined analysis, see Doc ID 2319046.1. For information about how to create a combined analysis with null (negative) reporting, see Doc ID 2319040.1. For information about how to write result column formulas in a combined analysis, see Doc ID 2319061.1. For information about Layout changes to consider in a combined analysis, see Doc ID 2319065.1.

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.