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.