Home » Creating a Cube in SSAS

Creating a Cube in SSAS

Creating a Cube in SSAS

1.In the Solution Explorer, make a right click on the Cubes folder and select “New Cube…”

2. On the Welcome to the Cube Wizard page, please click on Next.

3. On the “Select Creation Method” page, please select the option “Use existing tables”, and then click Next.

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.

5. On the “Select Measures” page, please verify all check box are checked, and click on Next.

6. On the “Select New Dimensions” page, make sure each check box is checked, then click on Next.

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.

8.Finally Cube is created as below:

Leave a Reply

Your email address will not be published.