Add Joins Between Dataset Tables

Add joins to indicate relationships between a fact table and the dimension tables.

Tutorial icon Tutorial

By default, when you drag and drop tables to a dataset, any joins defined in the data source are automatically created between the dataset's tables. Oracle Analytics also automatically creates joins base on the column name matches it finds between the tables. However Oracle Analytics can't always figure out how to automatically build joins. In such cases you must manually add joins before you can save the dataset.
If your dataset table contains deleted columns, then those columns aren't available to use in joins. If your dataset table contains hidden columns, then those columns are available to use in joins. See Hide or Delete a Column.
For information about using joins, see Understand Dataset Table Joins.
  1. On the Home page, click Navigator and then click Data.
  2. Click the Datasets tab.
  3. Locate the dataset that you want to open, click Actions, and then click Open.
  4. In the Join Diagram locate the table that you want to join to another table.
    Make sure that the fact table is the left-most table in the Join Diagram.
  5. Click the table and then drag and drop the selected table onto the target table that you want to join it to.
    The join icon is displayed in blue.
  6. Optional: Click the join to open the Join dialog and inspect the join.