Oracle Error ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.

Oracle Error Message

ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.

Reason for the Error

The named dimension was not in the relation’s dimension list.

Solution

Select only dimensions that are in the relation’s dimension list.