Oracle Solution for Error ora-36650

Solution for Oracle Error ORA-36650

ORA-36650: (XSDUNION10) Concat dimension workspace object

cannot be changed to UNIQUE. Leaves workspace object

and workspace object

share the value number

.

What triggered the Error:

Unique concat base dimensions cannot contain duplicate values.

What should we do to fix it:

Use MAINTAIN RENAME to change one of the duplicate values and retry.