The store table
appears on the schema tab, while the Select Table dialog remains open.
Add the following additional tables, after the manner of the store
table insertion above:
Click Close on the Select
Next, we'll add the Account
dimension, but we will use the Dimension Wizard for this, as it allows the
creation of a parent-child dimension.
Click Insert in the top Menu.
Select Dimension, and then
select New from the cascading menu, as shown in Illustration 34 below.
Select Insert -à Dimension -à New from the Top Menu
The Dimension Wizard
welcome dialog appears, as shown below.
The Dimension Wizard Welcome Dialog
Choose Parent-Child at the Choose
How You Want to Create the Dimension dialog that appears next, as shown in Illustration
Illustration 36: Selecting
the Parent-Child Radio Button
The Select the
Dimension Table dialog appears.
Select the account table.
The Details pane
is populated with the column names for the selected account table.