Finish (Dimension Wizard)

Analysis Services

Analysis Services

Finish (Dimension Wizard)

In this final step of the wizard, you can name your dimension and preview the dimension data. If you started the Dimension Wizard from Cube Editor or the Cube Wizard, you can also choose whether you want this to be a shared dimension or a private dimension.

Options

Dimension name

Type a unique name for your new dimension. You can enter a maximum of 24 characters for the dimension name, which must begin with an alphabetical character.

Create a hierarchy of a dimension

Select this check box to create a hierarchy and organize the dimension to support multiple hierarchies. For more information, see Creating Dimensions with Multiple Hierarchies.

Hierarchy name

Type a name for the new hierarchy. (This box is available only if you select the Create a hierarchy of a dimension check box.) The hierarchy name will be appended to the dimension name, separated by a period to distinguish the hierarchy from other hierarchies in the dimension.

Preview

Preview the hierarchy of your dimension.

Share this dimension with other cubes

Select this option to make this dimension a shared dimension. (This option is available only if you started the Dimension Wizard from Cube Editor or the Cube Wizard. Select it if you want your dimension to be available to other cubes.) If you choose to save this dimension as a shared dimension, the dimension will appear in the Shared Dimensions folder in the Analysis Manager tree pane.

If you started the Dimension Wizard from the shortcut menu of a Shared Dimensions folder in the Analysis Manager tree pane, your dimension will be shared automatically.