Example: Redundant or Overlapping Valid Intersection Rules Within the Same Valid Intersection Group
When valid intersection rules are within the same valid intersection group and produce any redundancy or overlap, the system marks an intersection valid if either of the valid intersection rule conditions are met.
Table 16-6 Example - Redundant or Overlapping Valid Intersection Rules Within the Same Valid Intersection Group
Valid Intersection Rule | Anchor Dimension - Account | Nonanchor Dimension - Entity |
---|---|---|
1 | IDESC(GP - Gross Profit) - Unselected members are invalid | IDESC(403 - Sales) |
2 | IDESC(GP - Gross Profit) - Unselected members are valid | IDESC(TD - Total Department) |
Because Gross Profit is a descendant of Net Income and Sales is a descendant of Total Department, inclusive descendants of Gross Profit are valid with any inclusive Descendant of Total Department. Rule 1 is a subset of Rule 2, so Rule 1 is effectively a "No operation" rule and is unnecessary. There is no restriction on inclusive descendants of Gross Profit accounts only being valid for inclusive descendants of Sales Entities.