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
In Solution Explorer, right-click the cube, and then click View Designer.
In the Design tab for the cube, click the Dimension Usage tab.
Either click the Add Cube Dimension button, or right-click anywhere on the work surface and then click Add Cube Dimension.
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
Concepts
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