ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values
Cause: Only UNIQUE concat dimensions can have custom member values or base dimensions which contain custom member values
Action: Remove all custom member values from the concat and all of its bases, and retry
https://support.oracle.com/
http://www.oracle.com/
ORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object
Cause: Duplicate concat leaf dimension was found
Action: Remove duplicate concat base dimensions and retry
ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values
Cause: The UNIQUE keyword was not specified in the concat dimension definition, and is required if any of its base dimensions contain custom member values
Action: Define the concat as UNIQUE, or remove all base custom member values
ORA-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype
Cause: Base dimensions of a unique concat must have TEXT or ID datatypes
Action: none
ORA-36639: (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number
Cause: Unique concat base dimensions cannot contain duplicate values
Action: Use MAINTAIN RENAME to change one of the duplicate values and retry
ORA-36638: (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object
Cause: A non-unique concat dimension cannot be used as a base of a dependent unique concat
Action: CHGDFN any non-unique concat base dimensions to UNIQUE and retry
ORA-36637: (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object
Cause: A non-unique concat dimension cannot be used as a base of a dependent unique concat
Action: CHGDFN any non-unique concat base dimensions to UNIQUE and retry
ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension
Cause: A non-unique concat dimension cannot be used as a base of a dependent unique concat
Action: CHGDFN any dependent unique concat dimensions to NOT UNIQUE and retry
ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition
Cause: Base dimensions of a unique concat must have TEXT or ID datatypes
Action: Specify a valid list of dimensions when defining a unique concat dimension
ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base
Cause: The user cannot specify INTEGER base dimensions when defining a concat dimension
Action: Change the datatype of the INTEGER base dimension, or omit it from the concat