Export (0) Print
Expand All

How to add a hierarchy to an existing dimension

SQL Server 2000

To add a hierarchy to a dimension with a previously identified hierarchy

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

  2. Right-click the shared dimension with an identified hierarchy in which you want to add a hierarchy, and then click Edit. Such dimensions have names where a period is used to separate the dimension name part from the hierarchy name part.

  3. In Dimension Editor, edit the dimension by adding or deleting levels or changing its schema. For more information, see Creating a Shared Dimension with the Editor.

  4. After editing the dimension, to save the dimension with a new hierarchy, on the File menu, click Save As to display the Dimension: New Name dialog box. To add a new hierarchy, change the hierarchy part of the name following the period in the New name box. (Do not change the dimension name part before the period.) Click OK.

    Important  When additional hierarchies are created for dimensions, the hierarchy part of the name should not equal any current or future level name or member name in the dimension because queries using the dimension may be ambiguous.

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

To add a hierarchy to a dimension without a previously identified hierarchy

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

  2. Right-click the shared dimension with an unidentified hierarchy in which you want to add a hierarchy, and then click Edit. The names of dimensions with unidentified hierarchies are those that do not contain periods.

  3. In Dimension Editor, to create a new dimension with a new hierarchy based on the selected dimension, on the File menu, click Save As to display the Dimension: New Name dialog box. In the New name box, provide a different dimension name followed by a period and a hierarchy name. Click OK.

    Important  When creating dimensions with multiple hierarchies, the hierarchy part of the name should not equal any current or future level name or member name in the dimension because queries using the dimension may be ambiguous.

  4. (Optional.) In Dimension Editor, edit the hierarchy of the dimension by adding or deleting levels or changing its schema. For more information, see Creating a Shared Dimension with the Editor.

  5. After editing the dimension and its hierarchy, on the File menu, click Save to save changes.

  6. (Optional.) To create additional hierarchies for the dimension, on the File menu, click Save As to display the Dimension: New Name dialog box. To add a new hierarchy, change the hierarchy part of the name following the period in the New name box. (In this case, do not change the dimension name part before the period.) Click OK.

  7. Repeat Steps 4 through 6 to edit and save the new hierarchy.

See Also

Adding Hierarchies to Existing Dimensions

Dimension Hierarchies

Show:
© 2014 Microsoft