On the Designer File menu, point to New,
and then click Dimension Table. Or, on the Designer
toolbar, click .
In the Target Table window, on the General page, in the Name field,
type a name for the table.
Note: Although it is
not required, you should follow a naming convention for your target tables.
One useful naming convention is to append _dim to signify a dimension table.
For example, Difficulty_dim.
(Optional) In the Description field, you
can type information about the table.
To specify the dimension table field, click the Target
Fields tab.
Note: You can define only
one field for a dimension table. (A time dimension table contains multiple
fields.)
To select the field, click the row in which it is displayed.
Because you cannot add or delete fields in a dimension table, the Add and Delete buttons
are unavailable. You can only edit the single dimension table field.