O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Image

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

Next, you identify ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required