Oracle Error ORA-30397: multiple JOIN KEY clauses specified for the same child level

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.