Oracle Solution for Error ora-36641

ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object

contains custom member values.

What triggered the Error:

The UNIQUE keyword was not specified in the concat dimension definition, and is required if any of its base dimensions contain custom member values.

What should we do to fix it:

Define the concat as UNIQUE, or remove all base custom member values.