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

a hierarchy with three levels, as shown in Figure 5-28 . This hierarchy
is created from columns in the three dimension tables that you selec-
ted earlier in the wizard.
Figure 5-28
4. Accept the defaults and complete the wizard. You've now success-
fully created a snowflake dimension with one hierarchy and several
attributes in Analysis Services 2005. The DSV of this dimension
shows the three dimension tables.
You can perform most of the same operations in a snowflake dimension as
you can in a star schema dimension, including adding attributes, creating
hierarchies, and defining member properties. Notice that the levels of the
hierarchy are actually referring to attributes that have been created from the
three dimension tables in the DSV pane. The wizard also defines the member
properties for the levels in the multi-level hierarchy. The member properties of
a specific level defined by the Dimension Wizard are all the columns that are
part of the dimension table. The member properties for the level Dim Product
Category are English Product Category Name, French Product Category
Name, Spanish Product Category Name. and Product Category Alt Key which
are all the remaining columns in the Dim Product Category table from which