How to fix the Oracle error ORA-30368: ATTRIBUTE cannot determine column in a different relation?

In this post, you’ll learn more about the Oracle ErrorORA-30368: ATTRIBUTE cannot determine column in a different relation with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-30368: ATTRIBUTE cannot determine column in a different relation

Reason for the Error ORA-30368: ATTRIBUTE cannot determine column in a different relation

An ATTRIBUTE clause in a dimension statement specified a determined column on the right that is in a different relation than that of the level on the left.

How to fix the Error ORA-30368: ATTRIBUTE cannot determine column in a different relation ?

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

Specify attibutes only for those dimension levels that functionally determine other columns within the same relation.