How to fix the Oracle error ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.?
In this post, you’ll learn more about the Oracle ErrorORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
Reason for the Error ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
The UNIQUE keyword was not specified in the concat dimension definition, and is required if any of its base dimensions contain custom member values.
How to fix the Error ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values. ?
You can fix this error in Oracle by following the below steps
Define the concat as UNIQUE, or remove all base custom member values.
Leave Your Comment