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.