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.