Oracle Error Message
ORA-37545: DIMENSION_MEMBER is part of a hierarchy loop.
Reason for the Error
A hierarchy has loops when the ancestor of a dimension member uses that member as its parent. Note that some loops are created across hierarchies. For example, in hierarchy 1, dimension member A is the parent of B, B is the parent of C and in hierarchy 2, C is that parent of A forms a hierarchy loop.
Solution
Change the hierarchies so that the loop is eliminated or move the problem hierarchy to a different dimension.
