Identifying the Primary Key for a Dimension Level

Use the Keys tab in the Logical Level dialog box to identify the primary key for a level.

To specify a primary key for a dimension level

1. In the Business Model and Mapping layer, expand a dimension and then expand the highest level (grand total level) of the dimension.
2. Double-click a logical level below the grand total level.
3. In the Logical Level dialog box, click the Keys tab.
4. In the Keys tab, from the Primary key drop-down list, select a level key.
   NOTE:  If only one level key exists, it will be the primary key by default.
5. To add a column to the list, perform the following steps:
   1. In the Logical Level dialog box, click New.
   2. In the Logical Level Key dialog box, type a name for the key.
   3. In the Logical Level Key dialog box, select a column or click Add.
   4. If you 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 Level Key dialog box and the check box is automatically selected.
6. If the level is in a time dimension, you can select chronological keys and sort the keys by name.
7. (Optional) Type a description for the key and then click OK.
8. Repeat Step 2 through Step 7 to add primary keys to other logical levels.
9. In the Logical Level dialog box, click OK