Oracle Solution for Error ora-30367

ORA-30367: a JOIN KEY clause is required

What triggered 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.

What should we do to fix it:

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