Oracle Solution for Error ora-36637

Solution for Oracle Error ORA-36637

ORA-36637: (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object

.

What triggered the Error:

A non-unique concat dimension cannot be used as a base of a dependent unique concat.

What should we do to fix it:

CHGDFN any non-unique concat base dimensions to UNIQUE and retry.