Creating an Analysis Services Cube with Visual Studio 2008 – Part 2

0
167
2 min read

Reviewing Jayaram’s other OLAP related articles may greatly help in understanding this article.

Creating a New Cube

The folder structure for the project developed in Part 1 is shown in the next figure. The Northwind.ds data source and the Northwind.dsv data source view were configured in Part 1. There are no pre-existing cubes in Nwind2008.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Right click the Cubes folder and from the drop-down menu you can create a new Cube.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Click on New Cube… menu item. This opens the Cube Wizard welcome window as shown.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Click on the Next button. This opens the Select Creation Method page of the wizard as shown. There are three options and the default is used for this article.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Click on the Next button. This opens the Select Measure Groups tables. At least one table must be chosen to continue. There is even the option of asking for a suggestion.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Click on the Suggest button at the top. The program goes through the motions and comes up with two tables as candidates for Measures group, the Products table and the Order Details table. You will see check marks appearing for these two tables. Accept the suggested tables for measures and click on the Next button.

This opens the Select Measures window where you can choose measures that you want to include in the Cube as shown.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Uncheck the ID related items in the Products table and click on the Next button. This brings up the Select New Dimensions window as shown in the next figure. Here also one could choose the needed items. For this article the default is accepted.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Click on the Next button. This takes you to the Completing the Wizard window which shows your Cube contents in a tree view as shown.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Now click on the Finish button. This creates the Cube as shown in the Solution Explorer.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Now you will see additional tabs open up for the Northwind.cube as shown. Using these tabs you can look at more details. These are outside the scope of this article.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Also separate windows gets displayed for Cube’s Measures and Dimensions as shown.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Also, the Data Source View of the Cube with the relationships between the Dimensions and Measures gets displayed as shown.

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

 


 

LEAVE A REPLY

Please enter your comment!
Please enter your name here