Lesson 2: Defining and Deploying a Cube

After you define a data source view in your Microsoft Analysis Services project, you are ready to define an initial Analysis Services cube.

You can define a cube and its dimensions in a single pass using the Cube Wizard. Alternatively, you can define one or more dimensions and then use the Cube Wizard to define a cube that uses those dimensions. If you are designing a complex solution, you generally start by defining the dimensions. For more information, see Dimensions in Multidimensional Models or Cubes in Multidimensional Models.


Completed projects for all of the lessons in this tutorial are available online. You can jump ahead to any lesson by using the completed project from the previous lesson as a starting point. Click here to download the sample projects that go with this tutorial.

This lesson contains the following tasks:

Next Lesson

Lesson 3: Modifying Measures, Attributes and Hierarchies

See Also


Analysis Services Tutorial Scenario

Multidimensional Modeling (Adventure Works Tutorial)

Dimensions in Multidimensional Models

Cubes in Multidimensional Models

Configure Analysis Services Project Properties (SSDT)

Build Analysis Services Projects (SSDT)

Deploy Analysis Services Projects (SSDT)