Creating the first cube

Now that the first dimension of your database has been created, it is time to start creating a cube that has some values that you can slice by the dimension. In Analysis Services, a database can contain several cubes. A cube is a structure that contains the data that you want to analyze. The data that you want to analyze are defined as measures and belong to a measure group. Another object of a cube is the dimensions. A cube can contain several measure groups and the measure groups can use the same dimensions to allow a user to analyze data from different subject areas.

Creating the Fact Internet Sales cube

To create the Fact Internet Sales cube, perform the following steps:

1. In the Solution Explorer window, right-click on the Cubes folder and select New Cube....

2. Click on Next in the wizard and then choose Use existing tables and click on Next again.

3. The measure group table that you want to use is the FactInternetSales table. Mark the checkbox and click on Next.

4. Now it is...