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

Creating a Dimension

Review the names of the dimensional tables before you start designing your dimensions.

You use the Dimension Wizard to create your dimensions.

Launch the Dimension Wizard
1. In the Solution Explorer of BI Dev Studio, right-click the Dimensions node.
2. From the menu that appears, select New Dimension. Bypass the Welcome page
of the wizard.

1. On the Select Creation Method page, select Use an Existing Table, as shown in
Figure 9.6.

FIGURE 9.6 Select the Build Dimension Using a Data Source option on the Select Build

Method page.

2. On the Specify Source Information page, under Data Source View, select a DSV to
base your dimension. Choose a main table for your dimension (from the Main Table
drop-down list). Under Key Columns, you will see a key column suggested for you
by BI Dev studio based on the key of the relational table. You can change that
column or add more columns if you would like a key attribute of your dimension to
be based on the composite key.
You can change the member name column for your key attribute in the Name
column drop-down list.
When you have everything as you like it, click Next.
3. If the Dimension Wizard detects that one or more tables are related to the selected
dimension table, your next page will be the Select Related Tables page, where you