Add Joins Between Dataset Tables
Add joins to indicate relationships between a fact table and the dimension tables.
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.