1. Visualizing Data in Oracle Analytics Server
  2. Visualize Data
  3. Connect to Your Data Using Datasets
  4. Use Joins to Build Datasets
  5. Add Joins Between Dataset Tables

Add Joins Between Dataset Tables

Add joins to indicate relationships between fact tables and dimension tables. For example, to identify a doctor for each patient you might join a table containing doctors' details to a table containing patient details using a common field DOCTOR_ID.

Tutorial icon Tutorial

When add tables to a dataset, Oracle Analytics automatically creates joins for related dataset tables based on the column name matches it finds between the tables. However if Oracle Analytics can't detect data relationships or you've turned off the Auto Join Tables option, you can manually create joins.
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 Datasets and locate the dataset that you want to open, click Actions, and then click Open.
  3. In the Join Diagram , hover over the first table, click the circle node that's displayed at the right-hand edge, and drag and drop over the target table that you want to join to.
    Description of join-node.png follows
    Description of the illustration join-node.png

    Tip: Don't drag the whole table over another table - this simply rearranges the tables.
  4. In the join dialog, select a join column from each table and a connector type (for example, =, >, <), then click outside the Join panel to close it.
    Description of data-set-editor-data-diagram-create-table-join.gif follows
    Description of the illustration data-set-editor-data-diagram-create-table-join.gif