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