Oracle Error ORA-36650: (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.

Oracle Error Message

ORA-36650: (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.

Reason for the Error

Unique concat base dimensions cannot contain duplicate values.

Solution

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