How to fix the Oracle error XOQ-02524: A SQL data type and an OLAP DML data type have both been specified and/or modified for cube storage. The OLAP DML cube storage data type specification will be ignored?

In this post, you’ll learn more about the Oracle ErrorXOQ-02524: A SQL data type and an OLAP DML data type have both been specified and/or modified for cube storage. The OLAP DML cube storage data type specification will be ignored with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-02524: A SQL data type and an OLAP DML data type have both been specified and/or modified for cube storage. The OLAP DML cube storage data type specification will be ignored

Reason for the Error XOQ-02524: A SQL data type and an OLAP DML data type have both been specified and/or modified for cube storage. The OLAP DML cube storage data type specification will be ignored

Cause: The data type for cube storage was specified in both SQL and in OLAP DML resulting in the use of the SQL data type.

How to fix the Error XOQ-02524: A SQL data type and an OLAP DML data type have both been specified and/or modified for cube storage. The OLAP DML cube storage data type specification will be ignored ?

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

Action: Specify a supported data type in either SQL or OLAP DML format.