Oracle Error ORA-30367: a JOIN KEY clause is required

Oracle Error Message

ORA-30367: a JOIN KEY clause is required

Reason for the Error

A JOIN KEY clause was omitted in a dimension statement. A JOIN KEY clause is required when the child level and the parent level are not in the same relation.

Solution

Specify a JOIN KEY clause to indicate how the relation of the child level joins to the relation of the parent level.