Dimension Design - Professional SQL Server Analysis Services 2005 with MDX - page 213

Figure 5-35
By default the Dimension Wizard defines the properties for the attribute modeling
the Parent-Child hierarchy at the completion of the Dimension Wizard, as shown in
Figure 5-36 .
Figure 5-36
The Parent-Child hierarchy is actually a special attribute hierarchy because it can
contain multiple levels, unlike the other attributes. The Parent-Child hierarchy that
you created is the attribute ParentEmployeeKey. The Usage property for this attrib-
ute is set to Parent, which indicates that this attribute is a Parent-Child hierarchy. If
you deploy the project and browse the Parent-Child hierarchy, you will notice that
you see the ids of parent and employee as a multilevel hierarchy. Typically, you
would want to see the names of the employees rather than their ids. You learned
earlier that you can use the named column to specify the name that is shown in the
browser and use the key column for ordering. Because the Parent-Child hierarchy
retrieves all the information from the Key attribute, which is the DimEmployee at-
tribute in this example, you need to modify the named column of the DimEmploy-
ee attribute rather than the named column of the Parent-Child hierarchy attribute.
Change the named column of the Key attribute to LastName. When you deploy