In this post, you’ll learn more about the Oracle ErrorXOQ-01200: metadata problem for MdmAttribute “string” with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
XOQ-01200: metadata problem for MdmAttribute “string”
Reason for the Error XOQ-01200: metadata problem for MdmAttribute “string”
Cause: Metadata for the MdmAttribute was incomplete or inconsistent. Possible causes are: 1) The MdmAttribute did not have an associated MtmAttributeMap. 2) The MtmAttributeMap existed, but there was no mapped expression for a requested MtmDimensionMap.
How to fix the Error XOQ-01200: metadata problem for MdmAttribute “string” ?
You can fix this error in Oracle by following the below steps
Action: If the MdmAttribute is created or modified using the OLAP Metadata API, then ensure that the object is created and mapped correctly. If the MdmAttribute is read from the OLAP Catalog, then run PL/SQL procedure CWM2_OLAP_VALIDATE.VALIDATE_OLAP_CATALOG with type_of_validation OLAP API. Correct any problems.