How to fix the Oracle error XOQ-01985: The ET attribute prefix of “string” specified for dimension “string” of cube “string” is invalid.?

In this post, you’ll learn more about the Oracle ErrorXOQ-01985: The ET attribute prefix of “string” specified for dimension “string” of cube “string” is invalid. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01985: The ET attribute prefix of “string” specified for dimension “string” of cube “string” is invalid.

Reason for the Error XOQ-01985: The ET attribute prefix of “string” specified for dimension “string” of cube “string” is invalid.

Cause: The ET attribute prefix was invalid. The ET attribute prefix: 1) Must be fewer than six characters 2) Cannot be a substring of any MdmDimensionality or MdmMeasure colummn names.

How to fix the Error XOQ-01985: The ET attribute prefix of “string” specified for dimension “string” of cube “string” is invalid. ?

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

Action: Correct the ET attribute prefix, or omit the prefix to use the default value.