Oracle® Business Intelligence Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in an Oracle BI Repository > Creating and Administering Logical Tables >

Reviewing Foreign Keys for a Logical Table


You can use the Foreign Keys tab to review the foreign keys for a logical table.

In fact tables, it is recommended that you use complex logical joins instead of foreign key logical joins. If complex logical joins are used, then there is more flexibility in defining the primary key. If the physical table has a primary key, then this field can be used as a logical key for the fact table. This is the method recommended for the Oracle BI repository.

CAUTION:  It is recommended that you do not have foreign keys for logical tables. However, you can create logical foreign keys and logical complex joins using either the Joins Manager or the Business Model Diagram. A logical key for a fact table must be made up of the key columns that join to the attribute tables. For more information, refer to Defining Logical Joins.

To review foreign key information for a logical table

  1. In the Business Model and Mapping layer, double-click a table.
  2. In the Logical Table dialog box, select the Foreign Keys tab.
  3. To review an existing foreign key, in the Foreign Keys list, select a key and click Edit.

    The Logical Foreign Key dialog box appears. For more information about changing information in this dialog box, refer to Defining Logical Joins.

Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.