ORA-30367: a JOIN KEY clause is required
Cause: 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
Action: Specify a JOIN KEY clause to indicate how the relation of the child level joins to the relation of the parent level
https://support.oracle.com/
http://www.oracle.com/