Manage Unknown Members in Analysis Services 2005, Part I - Page 4

November 15, 2007

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








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers