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 box -- Specifies whether to add, keep, or remove the members that are selected in this step.
Level box -- 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 box -- Specifies information about the condition that the data must meet.
Measure box -- 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 box -- Qualifies all of the dimensions of the measure other than the dimension whose members you want to select.
Qualify button -- Displays the Qualify Measure dialog box, in which you qualify the dimension members to use in a condition.
Operator box -- 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.
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 box -- 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 © 2001, 2005, Oracle. All rights reserved.