How to fix the Oracle error ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.?

In this post, you’ll learn more about the Oracle ErrorORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.

Reason for the Error ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.

The user cannot specify INTEGER base dimensions when defining a concat dimension.

How to fix the Error ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base. ?

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

Change the datatype of the INTEGER base dimension, or omit it from the concat.