Restrict Data Controls

Control

Description

Select Column

Displays the Select Column dialog box, enabling you to select a column from the current document.

Operator drop-down list

Select an operator for your criteria: Greater than (>), Greater Than or Equal To (>=), Equal to (=), Less Than or Equal To (<=), Less Than (<), Not Equal To (<>).

Operand drop-down list

Specifies one of three operands for restricting data:

  • A value Of - Restricts Data to a value or range of values.

  • The Data Value of Column - Displays a secondary Select Column button, enabling you to compare two columns.

  • A Missing Value - Enables restriction of missing values.

Value Text box

Enables you to enter the value for Restrict Data conditions.

Note:

Only use one member per dimension in filters when restrict data and /or retrieve top/bottom is applied. When multiple members are selected per dimension, the application aggregates the results. Because restrict data and retrieve top/bottom are parts of the Essbase query, the aggregation occurs after the query is returned and may result in unexpected result sets.