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

Oracle Error Message

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

Reason for the Error

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.

Solution

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