Restrict Data

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 limits.

The Information panel displays Analytic Services Restrict Data definitions for the current document.

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 30. Restrict Data Dialog Box 



Select Column

Displays the Select Column dialog box, used to select a column from the current document

Operator menu

Specifies an operator: Greater than (>), Greater Than or Equal To (>=), Equal to (=), Less Than or Equal To (<=), Less Than (<), Not Equal To (<>)

Operand menu

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 columns

  • 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.