How to fix the Oracle error XOQ-01443: Measure contains dimension “(string)”, which is not a primary dimension.?

In this post, you’ll learn more about the Oracle ErrorXOQ-01443: Measure contains dimension “(string)”, which is not a primary dimension. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01443: Measure contains dimension “(string)”, which is not a primary dimension.

Reason for the Error XOQ-01443: Measure contains dimension “(string)”, which is not a primary dimension.

Cause: An MdmMeasure referred to dimensions that were not primary dimensions.

How to fix the Error XOQ-01443: Measure contains dimension “(string)”, which is not a primary dimension. ?

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

Action: Use the OLAP Metadata API to change the MdmMeasure to refer to primary dimensions. If the measure is read from the OLAP Catalog, then change the catalog so the MdmMeasure refers only to primary dimensions.