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

Figure 5-2
Now you are ready to explore use of the Dimension Wizard in Analysis Ser-
vices 2005. The Dimension Wizard is capable of scanning the dimension
table(s), detecting relationships between columns within the table, and sug-
gesting hierarchies for the formation of the dimension. The following exercise
shows you how to create a dimension using the Geography table in the Ad-
venture Works DW data source. To do so, follow the steps below:
1. Launch the Dimension Wizard by right-clicking Dimensions in the
Solution Explorer and selecting New Dimension … as shown in Fig-
ure 5-3 . If the welcome screen of the Dimension Wizard opens up,
click Next.