How to create a shared dimension using the Dimension Wizard

To create a shared dimension using the Dimension Wizard

1. In the Analysis Manager tree pane, expand the database in which you want to create a shared dimension.
   
   
2. Right-click the Shared Dimensions folder, point to New Dimension, and then click Wizard.
   
   
3. In the second step of the wizard select either Star Schema: A single dimension table or Snowflake Schema: Multiple, related dimension tables. The other options are for parent-child, virtual, and data mining dimensions.
   
   
4. Follow the remaining wizard steps.

After you complete the wizard, Dimension Editor appears so that you can further refine the dimension.

See Also

Creating a Shared Dimension with the Wizard