How to fix the Oracle error ORA-37544: Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent.?

In this post, you’ll learn more about the Oracle ErrorORA-37544: Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-37544: Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent.

Reason for the Error ORA-37544: Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent.

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).

How to fix the Error ORA-37544: Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent. ?

You can fix this error in Oracle by following the below steps

Create a different level for the secondary hierarchy. This provides a separate level column for each hierarchy.