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

Oracle Error Message

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

Reason for the Error

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

Solution

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