Oracle Error ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.

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.