Database Reference
In-Depth Information
After the dimensions have been selected, clicking Next usually brings you to the end of the wizard, as shown
in Figure
11-6
(that is, unless the wizard senses that there could be additional dimensions created based on the
relationship lines in the data source view). In other words, if you created some of the dimensions, let's say only
four of the five dimension tables, the Cube Wizard will see that there is a missing dimension and offer to create it
for you in the Select New Dimensions dialog window (Figure
11-6
).
Figure 11-6.
The optional Select New Dimensions dialog window
the CUBe WIZarD CaN aLSO Create DIMeNSIONS
The Cube Wizard allows you to create dimensions while you create the cube. This means that when you
create a Visual Studio SSAS project, you do not necessarily have to start creating the dimensions before you
create the cube. instead, you can go right to creating the cube and have the wizard generate the basic outline
of your dimensions for you using the Select New Dimensions dialog window, as shown in Figure
11-6
. This option
does not provide you with any additional advantage over creating your dimensions first. Therefore, we have
found that using it is a somewhat redundant feature.
When you create all of the dimensions before launching the Cube Wizard, you immediately proceed to the
final dialog window of the wizard from the Select Existing Dimensions dialog window. In this window, you see
an overview of your design and have a chance to rename the cube to something appropriate. In our example in
Figure
11-7
, we named it DWPubsSalesVer1.
