How to fix the Oracle error XOQ-01722: Cube “string” mapping to “string” is invalid. Cubes must map to DimensionLevels for PrimaryDimensions whose keys are not unique.?

In this post, you’ll learn more about the Oracle ErrorXOQ-01722: Cube “string” mapping to “string” is invalid. Cubes must map to DimensionLevels for PrimaryDimensions whose keys are not unique. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01722: Cube “string” mapping to “string” is invalid. Cubes must map to DimensionLevels for PrimaryDimensions whose keys are not unique.

Reason for the Error XOQ-01722: Cube “string” mapping to “string” is invalid. Cubes must map to DimensionLevels for PrimaryDimensions whose keys are not unique.

Cause: AddUniqueKeyPrefix was set to True on an AWPrimaryDimensionOrganization, and a cube was not mapped to a DimensionLevel.

How to fix the Error XOQ-01722: Cube “string” mapping to “string” is invalid. Cubes must map to DimensionLevels for PrimaryDimensions whose keys are not unique. ?

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

Action: Either map the cube to a DimensionLevel or, if the keys are in fact unique, set AddUniqueKeyPrefix on the AWPrimaryDimensionOrganization to False.