Creating Restrict Data Definitions

  To create a Restrict Data definition:

1. Right-click a member, and select Analysis Tools , then Restrict Data.

   The Restrict Data dialog box is displayed.

2. From Select Column, select a column on which to restrict data.

3. From Operator, select an operator.

4. From Operand, select an operand: A Value Of, The Data Value of Column, or A Missing Value.

5. Depending on the selected operand, perform an action:

   • A Value Of — For Value, enter a data value.

   • The Data Value of Column — From the relevant list, select a column.

   • A Missing Value — Do nothing.

6. Click Add.

   Four buttons are available: Add, Update, Remove, and Remove All.

   Restriction criteria is listed in the Restriction Definition frame. You can use the Advanced button to create compound definitions.

   Table 31. Advanced Options  

   Option	Submenu	Description
   Add		Add the rule to Total Subset Definition
   Update		Replace the selected rule with the current rule
   Validate		Verify the parenthetical syntax of Total Subset Definition
   Remove		Remove the rule from Total Subset Definition
   Remove All		Remove all rules from Total Subset Definition
   Connect	And	Insert AND at the end of the rule. AND is used by default when multiple rules are added.
   	Or	Insert OR at the end of the rule
   Move	Move Up	Move the rule up in Total Subset Definition
   	Move Down	Move the rule down in Total Subset Definition

7. Optional: To compose a compound rule, select an advanced connect option, and repeat steps 2 through 7.

8. Click OK.