How to fix the Oracle error ORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2.?

In this post, you’ll learn more about the Oracle ErrorORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2.

Reason for the Error ORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2.

Two hierarchies are inconsistent when members that appear in both hierarchies have different ultimate leaves.

How to fix the Error ORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2. ?

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

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.