Dimension Wizard

Helps you create shared and private dimensions for your cube.

For more information about dimensions, see Dimensions.

The Dimension wizard appears when you click New Dimension in the Select Dimensions step of the Cube wizard.

An alternative way to start the Dimension wizard is to expand the Library folder under your database in the OLAP Manager tree view, right-click the Shared Dimensions folder, point to New Dimension, and then click Wizard. If you start the Dimension wizard in this way, you can create only shared dimensions.

The Dimension wizard has the following steps:

• Choose whether you want to use a single table or multiple tables for your dimension.
• Select the table or tables for your dimension.
• Define your dimension as either a standard or time dimension.
• Select the levels for your dimension.
• Name your dimension and preview its data.