Example: Redundant or Overlapping Valid Intersection Rules in Different Valid Intersection Groups
When valid intersection rules are in different valid intersection groups and produce any redundancy or overlap, the system marks an intersection valid only if it satisfies the requirements of all valid intersection groups.
In the following example, there are redundant or overlapping rules in different groups:
Table 15-7 Example - Redundant or Overlapping Valid Intersection Rules in Different Valid Intersection Groups
Valid Intersection Rule | Anchor Dimension - Account | Nonanchor Dimension - Entity |
---|---|---|
1 | IDESC(GP - Gross Profit) - Unselected members are valid | IDESC(403 - Sales) - Required |
2 | IDESC(NI - Net Income) - Unselected members are valid | IDESC(TD - Total Department) - Not required |
Because Group 1 is further restrictive for inclusive descendants of Gross Profit accounts being valid with inclusive descendants of Sales entities, the system enforces this group for these intersections. Other, non-Gross Profit accounts can still use all inclusive descendants of Total Department entities, but inclusive descendants of Gross Profit accounts must use inclusive descendants of Sales entities.