Adding Hierarchies to Existing Dimensions

Analysis Services

Analysis Services

Adding Hierarchies to Existing Dimensions

Two approaches can be used to add a hierarchy to an existing dimension. The first can be used if a hierarchy has already been defined for an existing dimension, and the second is used when no hierarchies have been defined. Both approaches involve using Dimension Editor.

The first approach involves editing an existing dimension with a defined hierarchy and saving it as a new dimension with a new hierarchy. The name part of the existing dimension is used followed by a period and a new hierarchy name part.

The second approach uses an existing dimension as the template for new dimensions with multiple hierarchies. If you are adding multiple hierarchies to an existing dimension that has no defined hierarchies, you can base the additional hierarchies on the existing dimension by renaming the dimension with a new dimension name part, a period, and a hierarchy name part. To create the next hierarchy, you use the new dimension name part followed by the period and a different hierarchy name part.

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.

To add a hierarchy to an existing dimension