23.
Within the Data
Source View pane, right-click ProductCategoryKey in the DimProductCategory
table.
24.
Click New
Attribute from Column from the context menu that appears, as depicted in Illustration
21.
Illustration
21: Select New Attribute from Column ...
25.
Right-click
the new entry, Product Category Key, that appears within the Attributes
pane of the Dimension Structure tab.
26.
Select Rename
from the context menu that appears, as shown in Illustration 22.
Illustration
22: Renaming the New Attribute ...
27.
Change the
name of the new Product Category Key attribute to Category within
the caption that is now enabled.
28.
Within the Properties
window for the renamed attribute, click the NameColumn property (located
within the Source section at the bottom of the Properties pane).
29.
Using the
downward arrow within the property cell, select (new), as depicted in Illustration
23.
Illustration
23: Select (new) ...
30.
Select DimProductCategory
within the Source table selector, and EnglishProductCategoryName
from within the Source column list, in the Object Binding dialog
box that appears next, as shown in Illustration 24.
Illustration
24: Make Object Binding Selections ...
31.
Click OK to
save our binding specifications and to dismiss the Object Binding
dialog.
32.
Within the Data
Source View pane, once again, right-click ProductSubcategoryKey in
the DimProductSubcategory table.
33.
Click New
Attribute from Column from the context menu that appears, as we did
earlier.
34.
Right-click
the new entry, Product Subcategory Key, that appears within the Attributes
pane of the Dimension Structure tab.
35.
Select Rename
from the context menu that appears, as we did before.
36.
Change the
name of the new Product Subcategory Key attribute to Subcategory
within the enabled caption.
37.
Within the Properties
window for the renamed attribute, click the NameColumn property (located
within the Source section at the bottom of the Properties pane).
38.
Using the
downward arrow within the property cell, select (new), as we did
earlier.
39.
Select DimProductSubcategory
within the Source table selector, and EnglishProductSubcategoryName
from within the Source column list, in the Object Binding dialog
box that appears next.
40.
Click OK to
save our binding specifications and to dismiss the Object Binding dialog,
once again.
The two new attributes appear within the Attributes pane
of the Dimension Structure tab, as depicted in Illustration 25.
Illustration 25: The Two
New Attributes within the Attributes Pane
We are
now ready to create a new hierarchy to house our new attributes as levels.
41.
Drag the Product
Name attribute from the Attributes pane into an unoccupied area
within the Hierarchies and Levels pane.
A new hierarchy, labeled Hierarchy by default,
appears within the Hierarchies and Levels pane, as shown in Illustration
26.
Illustration 26: The New
Hierarchy Appears ...
42.
Right-click
the Hierarchy label atop the new hierarchy.
43.
Select Rename
from the context menu that appears, as depicted in Illustration 27.
Illustration
27: Renaming the New Hierarchy ...
44.
Within the
enabled caption, replace the existing Hierarchy label with Product
Categories.
45.
Drag the Subcategory
attribute onto the new Product Categories hierarchy, aligning and
dropping it above the Product Name level within the hierarchy (the
cursor will form a red bar at the drop point), as shown in Illustration 28.
Illustration
28: Adding a New Level to the Hierarchy ...
46.
Drag the Category
attribute onto the new Product Categories hierarchy, aligning and
dropping it above the Category level we added immediately above.
The Product Categories hierarchy, with levels in
the desired order, appears within the Hierarchies and Levels pane as
depicted in Illustration 29.
Illustration 29: The New
Product Categories Hierarchy
47.
Click the top
portion of the new Product Categories hierarchy, to select it.
48.
Type the
following into the AllMemberName property (the top property setting
within the Advanced section of the Properties pane) of the new Product
Categories hierarchy:
All Products
The Properties pane for the Product Categories
hierarchy appears as shown in Illustration 30.
Illustration 30: The
AllMemberName Property within the Properties Pane
» 
Comment and Contribute
