Manage Unknown Members in Analysis Services 2005, Part I - Page 4November 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.
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.
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.
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.
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.
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.
42. Right-click the Hierarchy label atop the new hierarchy. 43. Select Rename from the context menu that appears, as depicted in Illustration 27.
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.
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.
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.
|
|
|
The Network for Technology Professionals
Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers
