Creating Restrict Data Definitions

To create a Restrict Data definition:

Perform one:
- Right-click a dimension member header and select Analysis Tools, then Restrict Data.
- Right-click a dimension member header and select Analysis Tools. When the Analysis Tools Manager is displayed, select New Restrict Data.
- Select Restrict Data from Data Layout Options.
- In the last step of the Document Creation wizard, click Restrict Data.
  The Restrict Data dialog box is displayed.
Click Select Column.
The Restriction Columns dialog box is displayed.
Select the Column to which the Restrict Data definition is applied, and click OK.
Focus is returned to the Restrict Data dialog box.
Select an operator from Operator.
Select an operand from the Operand menu: A Value Of, The Data Value of Column, or A Missing Value.
Enter a data value in Value, as needed.
Click Add.
The restriction criteria is listed in the Restriction Definition frame. You can use the Advanced button to create compound definitions with additional criteria.

Optional: Click Advanced to add criteria, update the definition, remove one or all definitions, connect individual definitions with an AND or OR, or move a criteria.

Advanced Option	Sub menu	Description
Add		Add the current rule to the Total Subset Definition.
Update		Replace the selected rule with the current rule.
Validate		Verifies the parenthetical syntax of the Total Subset Definition.
Remove		Remove the current rule from the Total Subset Definition.
Remove All		Remove all rules from the Total Subset Definition.
Connect	And	Inserts the AND operand at the end of the currently selected rule. The AND operand is used by default when multiple rules are added to the Definition.
	Or	Inserts the OR operand at the end of the currently selected rule.
Move	Move Up	Moves up the currently selected rule in the Total Subset Definition.
	Move Down	Move the currently selected rule down in the Total Subset Definition.

Click OK.