Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to create a dimension with multiple hierarchies in Dimension Editor

SQL Server 2000

To create a dimension with multiple hierarchies using Dimension Editor

  1. In the Analysis Manager tree pane, expand the database in which you want to create the dimension with multiple hierarchies.

  2. Right-click the Shared Dimensions folder, point to New Dimension, and then click Editor.

    In the Choose a Dimension Table dialog box, expand a data source, click the dimension table for the dimension, and then click OK. Dimension Editor appears with the dimension table showing in the Schema tab.

  3. To add more tables to the dimension, on the Insert menu, click Tables, and then use the Select Table dialog box.

  4. If the dimension contains multiple tables, ensure each is joined to another. To join two columns, in the Schema tab, drag one column to the other.

  5. Create levels in the dimension. It is easiest to create the highest, most general level first and then create progressively lower, more specific levels; otherwise, if member counting is enabled, a confirmation dialog box appears each time you add a level. For each level you want to create:
    1. On the Insert menu, click Level.

    2. In the Insert Level dialog box, select the column on which the level is based, and then click OK. As you create each level, it appears in the tree pane.
  6. (Optional.) In the properties pane, modify the properties of the dimension and its levels. For information about these properties, see Properties Pane (Dimension Editor Schema View).

  7. To save the dimension, on the File menu, click Save, type a name for the dimension in the New Dimension Name dialog box. To define a hierarchy for the dimension, this name must be of the form dimensionname.hierarchyname, where dimensionname is unique if there are no existing hierarchies or the same as another if it is another hierarchy of a dimension; hierarchyname is unique for each hierarchy being defined. Click OK.

  8. (Optional.) To create another hierarchy, repeat Steps 2 through 8.

See Also

Creating Dimensions with Multiple Hierarchies

Dimension Hierarchies

© 2015 Microsoft