ORA-37544
Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent.
Cause
The specified dimension was not "star consistent" (could not be represented in a star schema table).
Action
Ensure that each hierarchy maps to a single underlying column, and that levels shared across multiple hierarchies have the same set // of members in each hierarchy. Creating a different level for the secondary hierarchy will provide a separate level column for each hierarchy.
ORA-37544
Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent.
Cause
A dimension is "star consistent" when it can be represented in a star schema table. This requires that a hierarchy level map to a single underlying column. If a level is shared across one or more hierarchies, it must have the same set of members in each hierarchy (to share a column).
Action
Create a different level for the secondary hierarchy. This provides a separate level column for each hierarchy.
ORA-37544
Dimension members DIMENSION_MEMBER and MEMBER_ANCESTOR make this dimension star inconsistent.
Cause
A dimension is "star consistent" when it can be represented in a star schema table. This requires that a hierarchy level map to a single underlying column. If a level is shared across one or more hierarchies, it must have the same set of members in each hierarchy (to share a column).
Action
Create a different level for the secondary hierarchy. This provides a separate level column for each hierarchy.