Use this dialog box to select members by comparing to a range of data values in a measure. You use this box for measures that have numeric, date, or text data types only.
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, either between or not between.
Value 1 box -- Specifies the first value for the range, as described in the following list.
For numeric and text values, type the appropriate value.
For date values, type the appropriate value or use the controls to scroll through the values.
Value 2 box -- Specifies the second value for the range, as described in the following list.
For numeric and text values, type the appropriate value.
For date values, type the appropriate value or use the controls to scroll through the values.
Copyright © 2001, 2005, Oracle. All rights reserved.