Oracle® Business Intelligence Server Administration Guide > Creating and Administering the Physical Layer in an Oracle BI Repository > Defining Physical Foreign Keys and Joins >

Defining Physical Foreign Keys or Complex Joins with the Joins Manager

You can use the Joins Manager to view join relationships and to create physical foreign keys and complex joins.

To create a physical foreign key or complex join

  1. In the Administration Tool toolbar, select Manage > Joins.
  2. In the Joins Manager dialog box, perform one of the following tasks:
    • Select Action > New > Complex Join.

      The Physical Complex Join dialog box appears.

    • Select Action > New > Foreign Key. In the Browse dialog box, double-click a table.
  3. In the Physical Foreign Key dialog box, type a name for the foreign key.
  4. Click the Browse button for the Table field on the left side of the dialog box, and then locate the table that the foreign key references.
  5. Select the columns in the left table that the key references.
  6. Select the columns in the right table that make up the foreign key columns.
  7. If appropriate, specify a database hint.

    For more information, refer to Using Database Hints.

  8. To open the Expression Builder, click the button to the right of the Expression pane.

    The expression displays in the Expression pane.

  9. Click OK to save your work.
Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.