The Restrict Data analysis tool narrows the return set by requiring data values to be relevant to
rules and operands. Data can be restricted by two-column comparison or single-column fixed
The Information panel displays Analytic Services Restrict Data definitions for the current
Because Restrict Data is executed by Analytic Services, the network server is protected from
transmitting and the client is protected from processing large result sets.
Users can apply Restrict Data to result sets of processed queries (using the Analysis Tools right-
click menu) and of unsubmitted queries. The last step of the new document wizard enables users
to create Restrict Data definitions.
Table 106 6 Restrict Data Dialog Box
Displays the Select Column dialog box, used to select a column from the current document
Specifies an operator: Greater than (>), Greater Than or Equal To (>=), Equal to (=), Less Than or
Equal To (<=), Less Than (<), Not Equal To (<>)
Specifies one of three operands:
A value Of—restricts data to a value or range of values
The Data Value of Column—displays a secondary Select Column button, used to compare two
A Missing Value—restricts missing values
Value Text box
Specifies values for Restrict Data conditions
It is advised to use one member per dimension in filters when restrict data or retrieve top/bottom
is applied. If multiple members are selected per dimension, the application aggregates results.
Because restrict data and retrieve top/bottom are parts of Analytic Services queries, aggregation
occurs after queries are returned and may result in unexpected result sets.
Creating Restrict Data Definitions
To create a Restrict Data definition:
Right-click a member, and select Analysis Tools > Restrict Data.
The Restrict Data dialog box is displayed.
From Select Column, select a column on which to restrict data.
From Operator, select an operator.
From Operand, select an operand: A Value Of, The Data Value of Column, or A Missing Value.
Restrict Data a 345