ORA-37544: Dimension members DIMENSION_MEMBER and MEMBER_

michaeljet

ORA-37544: Dimension members DIMENSION_MEMBERand MEMBER_

ANCESTOR make this dimension starinconsistent.

Cause: A dimension is "star consistent"when it can be represented in a star

schema table. This requires that a hierarchy level map toa single underlying

column. If a level is shared across one or morehierarchies, it must have the same

set of members in each hierarchy (to share a column).

Action: Create a different level forthe secondary hierarchy. This provides a

separate level column for each hierarchy.