Converting Multiple Hierarchies into One Hierarchy

By default, when imported, the cubes resemble the Essbase hierarchy. Figure 38, Dimension with Multiple Hierarchies displays the Company Dimension after import.

Figure 38. Dimension with Multiple Hierarchies

This screen shot displays a dimension with multiple hierarchies.

You must convert multiple hierarchies into one hierarchy.

  To convert to a single hierarchy:

  1. Right-click on the dimension.

  2. Select Convert to Single Hierarchy View option. Results are as displayed in the following figure.

    This screen shot provides an example of a Dimension displayed as a single hierarchy.