O'Reilly logo

Getting Started with SQL Server 2012 Cube Development by Simon Lidberg

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 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 ...

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