Analysis Services
How to create a dimension with multiple hierarchies in the Dimension Wizard
To create a dimension with a single defined hierarchy using the Dimension Wizard
- In the Analysis Manager tree pane, expand the database in which you want to create a dimension with multiple hierarchies.
- Right-click the Shared Dimensions folder, point to New Dimension, and then click Wizard.
- In the second step of the wizard select either Star Schema: A single dimension table or Snowflake Schema: Multiple, related dimension tables.
- Follow the remaining wizard steps to define levels and various options for the dimension.
- In the Finish step of the wizard, enter a name in the Dimension name box.
- Select the Create a hierarchy of a dimension box.
- Enter a name in the Hierarchy name box.
- Click Finish to complete the wizard. After you complete the wizard, Dimension Editor appears so that you can further refine the dimension.
- (Optional.) To create another hierarchy of the dimension, from the File menu in Dimension Editor, point to New Dimension, and then click Wizard. Follow the steps in the next procedure, "To create a dimension with additional defined hierarchies using the Dimension Wizard," beginning with Step 3.
To create a dimension with additional defined hierarchies using the Dimension Wizard
- In the Analysis Manager tree pane, expand the database in which you want to define additional hierarchies for a dimension with at least one named hierarchy.
- Right-click the Shared Dimensions folder, point to New Dimension, and then click Wizard.
- In the second step of the Dimension Wizard select either Star Schema: A single dimension table or Snowflake Schema: Multiple, related dimension tables.
- Follow the remaining wizard steps to define levels and various options for the dimension.
- Select the Create a hierarchy of a dimension box.
- Select a dimension name having a defined hierarchy from the Dimension name box.
- Enter a name in the Hierarchy name box.
- Click Finish to complete the wizard. After you complete the wizard, Dimension Editor appears so that you can further refine the dimension.
- (Optional.) To create another hierarchy of the dimension, from the File menu in Dimension Editor, point to New Dimension, and then click Wizard. Repeat Steps 3 through 8.