Oracle Error Message
ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
Reason for 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.
Solution
Define the concat as UNIQUE, or remove all base custom member values.