In this post, you’ll learn more about the Oracle ErrorORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.
Reason for the Error ORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.
Duplicate concat leaf dimension was found.
How to fix the Error ORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object. ?
You can fix this error in Oracle by following the below steps
Remove duplicate concat base dimensions and retry.