How to fix the Oracle error ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.?

In this post, you’ll learn more about the Oracle ErrorORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.

Reason for the Error ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.

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

How to fix the Error ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values. ?

You can fix this error in Oracle by following the below steps

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