Use this dialog box to select members by comparing data values in a measure to a specific value. You use this dialog box for measures that have numeric, date, Boolean, or text data types.
Action
Specifies whether to add, keep, or remove the members that are selected in this step.
Level
Specifies whether to select members at all levels or at one or more particular hierarchy levels for the dimension. You can select More to display the Select Hierarchy/Levels dialog box.
Meeting Condition
Specifies information about the condition that the data must meet.
Measure. Specifies the name of the measure whose data values you want to compare. Select More to display the Select Measure dialog box or Qualify to display the Qualify Measure dialog box, in which you qualify the dimension members to use in a condition.
For. Specifies qualification for all of the dimensions of the measure other than the dimension whose members you want to select.
Qualify. Displays the Qualify Measure dialog box, in which you qualify the dimension members to use in a condition.
Operator. Specifies the operator to use for the comparison. The following list describes the operators that are available for each data type:
For Boolean values: equal to and not equal to.
For date values: after, before, on or after, on or before, equal to, and not equal to.
For numeric values: greater than, less than, greater than or equal to, less than or equal to, equal to, and not equal to.
For text values: contains, begins with, ends with, matches, does not match, greater than, less than, greater than or equal to, and less than or equal to.
Value. Specifies the value for the comparison, as described in the following list.
For Boolean values, select either true or false.
For date values, type the appropriate value or use the controls to scroll through the values.
For numeric and text values, type the appropriate value.
Copyright © 2003, 2007, Oracle. All rights reserved.