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 Designing Dimensions or Designing Cubes.

This lesson contains the following tasks:

• Defining a Dimension
  In this task, you use the Dimension Wizard to define a dimension.

• Defining a Cube
  In this task, you use the Cube Wizard to define an initial Analysis Services cube.

• Adding Attributes to Dimensions
  In this task, you add attributes to the dimensions that you created.

• Reviewing Cube and Dimension Properties
  In this task, you review the structure of the cube that you defined by using the Cube Wizard.

• Deploying an Analysis Services Project
  In this task, you deploy the Analysis Services project to your local instance of Analysis Services, and learn about certain deployment properties.

• Browsing the Cube
  In this task, you browse the cube and dimension data by using the browsers in Cube Designer and Dimension Designer.