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 46.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 46.30 Selecting the build method for the cube in the Cube Wizard.

Next, you identify ...

Get Microsoft SQL Server 2014 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.