Page 110 - DCAP606_BUSINESS_INTELLIGENCE
P. 110
Unit 7: Creating Cube
In this screen you need to select any existing dimensions. We have created three dimensions and Notes
we will include all of these dimensions as shown below:
Figure 7.4: Select Existing Dimensions
Source: http://www.mssqltips.com/tutorialimages/2008_Cube_Wizard_Step_4.jpg
In the next screen, we can select if we want to create any additional new dimensions from the
tables available in the DSV. We do not want to create any more dimensions, so unselect any
selected tables as shown below and move to the next screen.
Figure 7.5: Select New Dimensions
Source: http://www.mssqltips.com/tutorialimages/2008_Cube_Wizard_Step_5.jpg
LOVELY PROFESSIONAL UNIVERSITY 105
