Create a New Cube
Applies to: SQL Server 2008 RC 0.
After creating a Data Source View in the previous step, we are now ready to
create a cube using the Cube Wizard of SQL Server Business Intelligence
Development Studio.
1. In the Solution Explorer, make a right click on the Cubes folder and
select "New Cube..."
![](images/AnalysisServices_0005_0001.PNG)
2. On the Welcome to the Cube Wizard page, please click on Next.
![](images/AnalysisServices_0005_0002.PNG)
3. On the "Select Creation Method" page, please select the option "Use
existing tables", and then click Next.
![](images/AnalysisServices_0005_0003.PNG)
4. On the "Select Measure Group Tables" page, after making sure the data
source view we created before is selected, make a click on "Suggest" to
have the
Wizard suggest you which tables to use on the Cube. Then click on Next to go to
the next step.
![](images/AnalysisServices_0005_0004.PNG)
5. On the "Select Measures" page, please verify all check box are checked,
and click on Next.
![](images/AnalysisServices_0005_0005.PNG)
6. On the "Select New Dimensions" page, make sure each check box is
checked, then click on Next.
![](images/AnalysisServices_0005_0006.PNG)
7. On the "Completing the Wizard" page, change the content of the "Cube
name:" text box for the text "Adventure Works DW", and click Finish.
![](images/AnalysisServices_0005_0007.PNG)
![](images/AnalysisServices_0005_0009.PNG)