Blend Datasets

If your workbook contains multiple datasets, then you can blend data in one dataset with data in another dataset.

When you add more than one dataset to a workbook, the system tries to find matches for the data that’s added. It automatically matches external dimensions where they share a common name and have a compatible data type with attributes in the existing dataset. Blending relationships are stored in the tables and not in the workbook. So any blending matches that you add or remove affects the other datasets that use the same tables.

See Understand Blending.

Datasets that use Oracle Essbase or Oracle EPM Cloud connections aren't available for blending.

Note:

Datasets can include tables from different connections and schemas. These datasets use joins, which are defined in the Dataset editor. To reduce or eliminate blending in workbooks, Oracle suggests that whenever possible you create datasets that contain multiple tables and use joins. See Create a Dataset from a Connection.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. To add another dataset to the workbook, click Data, and in the Data pane, click Add (+), and then Add Dataset.
3. In the Add Dataset dialog, select a dataset and click Add to Workbook.
4. In the Data page, go to the Data Diagram and locate the datasets to blend.
5. Click the number between the dataset icons.
   
   
6. Optional: To change the match for a column, click the name of the column and select a different column.

   If columns have the same name and same data type, then they’re recognized as a possible match. You can customize this and specify that one column matches another by explicitly selecting it even if its name isn’t the same. You can select only those columns with a matching data type.

7. Optional: Click Add Another Match, and in the table, select the columns that you want to join.
8. Optional: For a measure that you’re uploading for the first time, specify the aggregation type such as Sum or Average.
9. Click OK.