Creating Valid Intersections

You can define rules to filter certain cell intersections to users when they enter data, select members, or select runtime prompts.

To create a valid intersection:

  1. Click Application, and then click Valid Intersections.
  2. If it isn't already selected, click the Setup tab.
  3. Create the valid intersection group:
    1. Click Create.
    2. Enter a name and description for the new intersection.
    3. The Enabled checkbox is selected by default. To disable the valid intersection group, clear the Enabled checkbox. You can also enable or disable a valid intersection group directly on the Valid Intersections page. See Disabling and Enabling Valid Intersection Groups.
    4. For Definition Type, select one of the following:
      • Valid Intersection
      • Valid Intersection
    5. To select the anchor dimension for the intersection group, click down arrow icon next to Select Anchor Dimension.
    6. Optional: By default, the anchor dimension members that are not specified in the valid intersection rule are marked valid. To clear this option, click down arrow icon next to the anchor dimension, and then click Unselected members are valid.

      For an explanation of this option and for an example of how it's used, see Anchor and Nonanchor Dimensions.

    7. To select additional dimensions (called nonanchor dimensions), click Add Dimension.
    8. Optional: By default, nonanchor dimensions are not required. To make a nonanchor dimension required, click down arrow icon next to the nonanchor dimension, and click Required.
  4. Define the valid intersection rule:
    1. Click Add Rule.
    2. To select the range of members to include, exclude, or remove in the valid intersection, click the drop-down icon next to the dimensions in the new rule:
      • Click Edit to open the Select Members page and select the members, substitution variables, and attributes to include in the valid intersection rule. See Using the Member Selector

      • Click Add Exclusion to define an exclusion in the rule. You can exclude a subset of what is included for that dimension.

      • Click Clear to clear the selection.

        To delete a rule, click the Delete icon.

  5. Click Save and Close.
  6. The new valid intersection group is added to the end of the valid intersections list. To reorder the rules in the list, see Changing the Valid Intersection Group Evaluation Order.