Oracle Solution for Error ora-36643

ORA-36643: (XSDUNION21) Concat dimension workspace object

cannot be changed to NOT UNIQUE because it contains custom member values.

What triggered the Error:

Only UNIQUE concat dimensions can have custom member values or base dimensions which contain custom member values.

What should we do to fix it:

Remove all custom member values from the concat and all of its bases, and retry.