How to fix the Oracle error XOQ-01432: Primary dimension and union hierarchy map are inconsistent: union hierarchy map does not contain hierarchy map for “(string)”.?

In this post, you’ll learn more about the Oracle ErrorXOQ-01432: Primary dimension and union hierarchy map are inconsistent: union hierarchy map does not contain hierarchy map for “(string)”. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01432: Primary dimension and union hierarchy map are inconsistent: union hierarchy map does not contain hierarchy map for “(string)”.

Reason for the Error XOQ-01432: Primary dimension and union hierarchy map are inconsistent: union hierarchy map does not contain hierarchy map for “(string)”.

Cause: The hierarchies contained in an MdmPrimaryDimension were inconsistent with the hierarchy maps contained in the corresponding MtmPrimaryDimensionMap.

How to fix the Error XOQ-01432: Primary dimension and union hierarchy map are inconsistent: union hierarchy map does not contain hierarchy map for “(string)”. ?

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

Action: Use the OLAP Metadata API to correct the MdmPrimaryDimension or MtmPrimaryDimensionMap so they are consistent.