Oracle Error Message
ORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2.
Reason for the Error
Two hierarchies are inconsistent when members that appear in both hierarchies have different ultimate leaves.
Solution
This problem is usually resolved by defining a new dimension member for the secondary hierarchy, or fixing the hierarchy table so that the definitions of the member match across hierarchies.