Restricting Data

The Restrict Data analysis tool provides another means of narrowing the return set, by requiring data values to be relevant to rules and operands. Data can be restricted by a comparison between columns or using fixed limits on one column.

The Information panel Restrict Data segment is displayed Essbase Restrict Data definitions for the current document.

Restrict Data is executed by Essbase. This can protect the network server from transmitting, and the client from processing, large result sets.

Although you can apply Restrict Data to the result set of a processed query (using the Analysis Tools shortcut menu), you can also define Restrict Data criteria before submitting a query. The last step in the Document Creation wizard enables you to create Restrict Data definitions.

Topics that discuss restricting data: