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 >

Specifying a Primary Key in a Logical Table

After creating tables in the Business Model and Mapping layer, you specify a primary key for each table. Logical dimension tables must have a logical primary key. Logical keys can be composed of one or more logical columns.

NOTE:  Logical keys are optional for logical fact tables. However, it is recommended that you do not specify logical keys for logical fact tables. For more information, refer to Reviewing Foreign Keys for a Logical Table.

To specify a primary key in a logical table

1. In the Business Model and Mapping layer, double-click a table.
2. In the Logical Table dialog box, select the Keys tab and then click New.
3. In the Logical Key dialog box, perform the following steps:
   1. Type a name for the key.
   2. Select the check box for the column that defines the key of the logical table.
4. Click OK.