Oracle Error Message
ORA-37544: Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent.
Reason for the Error
A dimension is “star consistent” when it can be represented in a star schema table. This requires that a hierarchy level map to a single underlying column. If a level is shared across one or more hierarchies, it must have the same set of members in each hierarchy (to share a column).
Solution
Create a different level for the secondary hierarchy. This provides a separate level column for each hierarchy.