Specify a Logical Table's Primary Key

After creating logical tables and adding columns to them, you specify a primary key for each dimension table.

Logical dimension tables must have a logical primary key. A logical primary key can be a composite key, which is composed of one or more logical columns. Oracle advises against specifying logical keys for logical fact tables.

1. On the Home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer and locate and double-click the logical table that you want to add a primary key to.
4. In the logical table, click the General tab.
5. Click the Primary Key field and select the column that you want to use as the table's primary key.
6. Optional: If the primary key is a composite key, then click the Primary Key field and select another column.
7. Click Save.