ORA-30397: multiple JOIN KEY clauses specified for the same child level
What triggered the Error:
Multiple JOIN KEY clauses were specified for a given child level in a dimension hierarchy.What should we do to fix it:
Eliminate the redundant JOIN KEY clauses.