How to: Add a Dimension to a Cube

You add a dimension to a cube by using the Dimension Usage view in Cube Designer, which you can access from Business Intelligence Development Studio.

To add a dimension to a cube

  1. In Solution Explorer, right-click the cube, and then click View Designer.

  2. In the Design tab for the cube, click the Dimension Usage tab.

  3. Either click the Add Cube Dimension button, or right-click anywhere on the work surface and then click Add Cube Dimension.

  4. In the Add Cube Dimension dialog box, use one of the following steps:

    • To add an existing dimension, select the dimension, and then click OK.
    • To create a new dimension to add to the cube, click New dimension, and then follow the steps in the Dimension Wizard.

After you add a dimension to a cube, you must specify the usage for the dimension. For more information, see How to: Specify Dimension Usage for a Cube Dimension.

See Also


Defining and Configuring Dimensions, Attributes, and Hierarchies
Defining and Configuring Cubes and Cube Properties

Other Resources

Cube Basics How-to Topics (Analysis Services)
Working with Database Dimension Basics How-to Topics

Help and Information

Getting SQL Server 2005 Assistance