How to fix the Oracle error ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.?

In this post, you’ll learn more about the Oracle ErrorORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.

Reason for the Error ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.

An ineligible dimension was specified in the Qualified Data Reference

How to fix the Error ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation. ?

You can fix this error in Oracle by following the below steps

Do not attempt to qualify this dimension.