- Using Oracle Business Intelligence or Oracle Analytics for Oracle Taleo Enterprise Edition
- Combining Columns from one or more Subject Areas
Combining Columns from one or more Subject Areas
Before you start
BI Author Limited
BI Author Developer
BI Tenant Administrator
Home > Oracle Analytics > Catalog
Here's what to do
- Create or edit an analysis.
- In the Analysis editor, create an empty analysis that uses a subject area such as Recruiting.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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:
- Click the Options button for the Average Submission Cycle column.
- Select Column Properties.
- Select Column Format.
- Ensure that Custom Headings is selected.
- In the Column Heading box, enter
Average Time to Complete Required Tasks
. - Click OK.
- Click the Results tab to view the columns in a table in the Compound Layout.