At this stage, let's
focus upon the Product dimension. As we determined the case to be for
the Store dimension, member naming for the Product dimension will
be quite straightforward; we will simply swap the already present Product
name for the Product ID that appears in the Member Name Column
property.
48.
Right-click the product_id
dimension.
49.
Select Rename from the
context menu, and change the label to Product.
50.
Click the Advanced tab
in the Properties pane.
51.
Select the All Caption
property.
52.
Change the All Caption
property to read "All Products."
53.
Drag the product_id
field from the product table over to drop onto the Product
dimension in the cube tree.
54.
Right-click the Product_id
level that appears.
55.
Select Rename from the
context menu, and type in Product.
56.
Click the Basic tab in
the Properties pane.
57.
Select the Member Name
Column property.
58.
Click the ellipses button ("..").
The Select Column
dialog appears.
59.
Select the product_name
column by clicking, as shown in Illustration 41 below.
Illustration 41:
Select product_name for the Member Name Column Property
60.
Click OK.
The Properties
pane for the new Product level, with the modification we have enacted,
should appear as shown below:
Illustration 42: The Modified Properties, Product Level
Member of the Category Dimension
Finally,
one step remains to make the Revenue cube identical to the Expense
cube in all significant respects: the addition of an Account
dimension. Next, we'll add the Account
dimension, using the Dimension Wizard as we did for the Expense cube, as
it allows the creation of a parent-child dimension. Creating the
dimension a second time within this lesson will also afford us some more
practice with the process.
61.
Click Insert in the top
Menu.
62.
Select Dimension, then
select New from the cascading menu, as shown in Illustration 43
below.
Illustration 43:
Select Insert --> Dimension --> New from the Top Menu
The Dimension Wizard
welcome dialog appears, as shown below.
Illustration 44:
The Dimension Wizard Welcome Dialog
63.
Click Next.
64.
Choose Parent-Child at
the Choose How You Want to Create the Dimension dialog that appears
next, as shown in Illustration 45 below.
Illustration 45:
Selecting the Parent-Child Radio Button
65.
Click Next.
The Select the
Dimension Table dialog appears.
66.
Select the account
table.
The Details pane
is populated with the column names for the selected account table, as
depicted below.
Illustration 46:
The account Table Columns in the Detail Pane
67.
Click Next.
» 
Comment and Contribute
