Oracle Error ORA-30345: circular dimension hierarchy

Oracle Error Message

ORA-30345: circular dimension hierarchy

Reason for the Error

A circularity was found the dimension hierarchy.

Solution

Check the hierarchy for a level name that occurs more than once.