Oracle Error Message
ORA-30397: multiple JOIN KEY clauses specified for the same child level
Reason for the Error
Multiple JOIN KEY clauses were specified for a given child level in a dimension hierarchy.
Solution
Eliminate the redundant JOIN KEY clauses.