Oracle Error ORA-30337: multiple JOIN KEY clauses specified for the same parent level

Oracle Error Message

ORA-30337: multiple JOIN KEY clauses specified for the same parent level

Reason for the Error

Multiple JOIN KEY clauses were specified for a given parent level in a dimension hierarchy.

Solution

Match up each JOIN KEY clause with the level it references in the hierarchy. Eliminate the redundant JOIN KEY clause.