Multidimensional Models and Business Intelligence Development Studio - Microsoft SQL Server 2008 Analysis Services - page 115

can select additional tables. When you have selected your tables, click Next. (This
page will not appear if there is only one possible dimension table in your DSV.)
4. On the Select Dimension Attributes page, you can see the attributes that Analysis
Services suggests in the Attribute Name column. (That column contains all the attrib-
utes found in the dimension tables.) You can reject the suggestions and substitute
your own, and you can change the names of the attributes, as shown in Figure 9.7.

FIGURE 9.7 Select the dimension attributes on the Select Dimension Attributes page.

In the Attribute Key Column, you will find the key column for the attribute. If you
select a key column, you will enable a drop-down list from which you can change
the column.
In the Attribute Name Column, you will find the name column for the attribute.
Just like with the key column, you can select a new column.
When satisfied with all your selections and changes, click Next.
5. On the Completing the Wizard page, you can review the dimension structure and
name your dimension. After you click Finish, the Dimension Editor appears with
your new dimension.

In Analysis Services 2008, the Dimension Wizard has been greatly simplified. It does
not suggest that you choose the dimension type or that you start building hierar-
chies. You will use Dimension Editor to finish your dimension design.

Modifying an Existing Dimension

Now we are going to use the Dimension Editor in BI Dev Studio to modify the Customer
dimension. Double-click the Customer dimension in the Solution Explorer, and the
Dimension Editor will open, with the Dimension Structure tab showing, as shown in
Figure 9.8.