Microsoft® SQL Server 2012 Unleashed

Creating the Cube

Most of the hard work in the CompSales International example is done. All that is left to do now is to create a cube that is based on your fact tables in your data source, use the dimensions and hierarchies you just defined, and then process it (that is, populate the cube with data). In the Solution Explorer, you right-click the Cubes object and select New Cube. This invokes the Cube Wizard, as shown in Figure 53.30. This first step in the wizard is asking you how you want to create the cube. We will select the Use Existing Tables option.

FIGURE 53.30 Selecting the build method for the cube in the Cube Wizard.

Next, you identify ...