Siebel Business Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a 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.

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, see Defining Logical Joins.

Joins and Fact Tables

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.

NOTE:  This is the method recommended for the analytics repository.

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, see Defining Logical Joins.