Oracle Solution for Error ora-33219

ORA-33219: (CINSERT05) %K cannot be added to workspace object

because it is already a value of the dependent UNIQUE concat dimension workspace object

, from leaf dimension workspace object

.

What triggered the Error:

A value cannot be added to a dimension if it conflicts with an existing value in a unique concat dimension containing this dimension.

What should we do to fix it:

The concat(s) causing the conflict could be CHGDFNed to NOT UNIQUE, or either of the duplicate values could be renamed to make them UNIQUE.