5.1.2 Validations in EDMCS

In our EDMCS setup, the following validation rules are implemented to maintain hierarchy integrity and ensure consistency across dimensions:

1. All leaf nodes must be shared for all hierarchies as leaf nodes

• What it means: The lowest-level items (leaf nodes) must be the same across all hierarchies of a dimension.
• Applicability: This rule is enforced when multiple alternative hierarchies exist for a given dimension
• Example: If "Product" dimension has Product A as leaf in one hierarchy, then Product A must appear as leaf in every other hierarchy.

Intermediate nodes must be unique across a dimension

• What it means: A non-leaf node cannot be shared whatsoever. By extension, a specific parent–child link can only belong to one hierarchy.
• Example: If “Product Y” is a leaf node and "Category X → Product Y" is a parent-child relationship in one hierarchy, the exact same relationship cannot appear in another hierarchy.
• But allowed: Leaf nodes can have a different parent across hierarchies as long as respective parent names in those hierarchies are unique.

  Note:

  • All hierarchies must have the same leaf nodes.
  • But the way these leaf nodes are related to their parent (parent–child links) must be unique in each hierarchy.