When you edit hierarchies, be aware that they may be used in cube schemas and Essbase models. Changing the hierarchy will cause the cube schemas and the models built it from it to be out of sync with the hierarchy. Oracle recommends recreating the cube schema and Essbase model when yo make changes to the underlying hierarchies.
To edit a hierarchy:
Select the hierarchy in the Metadata Navigator, right-click, and select Edit.
If you are editing a standard or measure hierarchy, follow the procedure in Creating Standard and Measure Hierarchies, starting at step 2.
If you are editing a calendar hierarchy, see Creating Calendar Hierarchies, select the appropriate calendar type, and follow the procedure for that calendar type, starting at step 2.