HIERARCHY hierarchy (child_level CHILD OF parent_level [ CHILD OF parent_level ]... [ dimension_join_clause ] )