Export (0) Print
Expand All

How to: Add a Dimension to a Cube

SQL Server 2005

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.

  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft