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