Siebel 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. NOTE: Logical dimension tables must have a logical primary key. Logical keys can be composed of one or more than one logical columns. Logical keys are optional for logical fact tables.
To specify a primary key in a logical table
- In the Business Model and Mapping layer, double-click a table.
- In the Logical Table dialog box, select the Keys tab and then click New.
- In the Logical Key dialog box, perform the following steps:
- Type a name for the key.
- Select the check box for the column that defines the key of the logical table.
- To add a column to the Columns list:
- Click Add.
- In the Browse dialog box, select the column, and then click OK.
The column you selected appears in the Columns list of the Logical Key dialog box.
- (Optional) Type a description for the key.
- Click OK.
|