Database Reference
In-Depth Information
Figure 9-37.
Selecting the main table for the dimension
Once you select a table, select one or more columns that define the table's dimensional keys. Ordinarily, they
are singular key columns such as the TitleKey in Figure
9-38
. If you have a composite key, you can select a second
column by clicking the “Add key column” option (covered by the dropdown box in Figure
9-36
) after you choose
the initial key column.
Figure 9-38.
Selecting the key columns for the dimension
■
if you want to undo a selection, highlight the errant column, open the dropdown box and click the blank area
just above the column listing. in Figure
9-38
, the blank area is just above the TitleKey.
Tip
