How to fix the Oracle error ORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.?

In this post, you’ll learn more about the Oracle ErrorORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.

Reason for the Error ORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.

Only UNIQUE concat dimensions can have custom member values.

How to fix the Error ORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE. ?

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

Use the CHGDFN command to change the concat dimension to UNIQUE and retry.