To edit a dimension hierarchy

1.	Open the Dimension Hierarchies window.

2.	You may need to load the dimension hierarchy you want to edit.

3.	Select the dimension hierarchy you want to edit.

4.	Click Edit.

5.	Modify the following details for the dimension hierarchy:

The Dimension Name

A Description

The Number of Levels in the dimension hierarchy. This should correspond to the hierarchical levels in the database table to which you are mapping this dimension hierarchy.

If you are using this dimension hierarchy as the basis for a cube, ensure that Elements are Mutually Exclusive is checked (by default, this option is checked). Otherwise, you will receive an error when you use this dimension hierarchy to create a cube because the elements cannot overlap in a cube.

6.	To modify the table mapping, click Map Table.

The Edit Table Definition window opens.

7.	Follow the instructions in To map a base record table to an existing database table.

8.	After you finish mapping your dimension, you return to the Edit Dimension window, which now includes details for the new dimension hierarchy.

Click OK.

You return to the Dimensions window.

10.	(Optional but recommended) You can store your changes to any dimension hierarchies for future use in a table catalog by clicking Save.