Combining Columns from one or more Subject Areas

Before you start

You must have one of the following user type permissions:

• BI Author Limited

• BI Author Developer

• BI Tenant Administrator

Home > Oracle Analytics > Catalog

Here's what to do

1. Create or edit an analysis.
2. In the Analysis editor, create an empty analysis that uses a subject area such as Recruiting.
3. In the Criteria tab, select the columns to include in the analysis. For example, select Name from the Candidates folder and Average Submission Cycle Time from the Candidate Cycle Time folder.
4. In the Selected Columns pan, click the Combine results based on union, intersection, and difference operations toolbar button to display the Select Subject Area menu.
5. Select a subject area that contains the columns to combine with the columns that you have previously included. For example, click Talent Profile.

   The Set Operations area is displayed in the Selected Columns pane. Note the boxes with dotted line borders that are displayed below the criteria. These boxes indicate the kind of column that you must combine with those that you have previously included. For example, the boxes might include "Add Column (Name)" and "Add Column (Average Submission Cycle Time)". This text indicates that the columns that you include in each of those boxes is combined with the previously selected Name and Average Submission Cycle Time columns using a Set operation to form a new column. When you combine measure columns, no arithmetic operations are performed.

6. In the Subject Areas pane, select the columns to combine with the originally selected columns. For example, from the Employee folder, select Name and from the Talent Profile Facts folder, select Average Time to Complete Talent Profile.
   Note that the boxes that previously had dotted line borders now hold the columns that you have just selected. You have now specified the columns to combine.
7. Click the Union button under the Result Columns link. Select the operation type to use for combining the columns. For example, select the Union All type.
   The result columns are those that are displayed in views after applying the set operation of the derived columns.
8. Click the Result Columns link. Note that the Selected Columns pane is updated to show the newly combined columns that you have just created. You can work with these columns as you do other columns in this pane. For example, you can rename the first column (that is the single newly combined column) by following these steps:
   1. Click the Options button for the Average Submission Cycle column.
   2. Select Column Properties.
   3. Select Column Format.
   4. Ensure that Custom Headings is selected.
   5. In the Column Heading box, enter Average Time to Complete Required Tasks.
   6. Click OK.
9. Click the Results tab to view the columns in a table in the Compound Layout.