O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

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

Using the Wizard to Create a Cube

The Cube Wizard guides you through the process of selecting the fact table data and the dimensions that you bring together into a cube. In the Cube Wizard, you select a data source view. All of the fact and dimension tables for the cube must be in that data source view. You then identify the fact table columns that will be used to create measures in the cube. For each fact table, the wizard will create a measure group that contains the measures created from the columns in the table. In each measure group, you can also create a measure that counts the number of rows in the fact table. A cube requires at least one measure group that must contain at least one measure, but you most likely will choose to have several ...

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