How to fix the Oracle error XOQ-01721: ValueHierarchy “string” does not have unique keys.?

In this post, you’ll learn more about the Oracle ErrorXOQ-01721: ValueHierarchy “string” does not have unique keys. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01721: ValueHierarchy “string” does not have unique keys.

Reason for the Error XOQ-01721: ValueHierarchy “string” does not have unique keys.

Cause: AddUniqueKeyPrefix was set to True on an AWPrimaryDimensionOrganization, and a load was attempted on a ValueHierarchy.

How to fix the Error XOQ-01721: ValueHierarchy “string” does not have unique keys. ?

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

Action: Do one of the following: 1) Perform the load on DimensionLevels. 2) If the keys are in fact unique, then set AddUniqueKeyPrefix on the AWPrimaryDimensionOrganization to False.