Use this dialog box to select members based on whether data values of one measure are within a specified range of data values of another measure. You use this box to compare only measures that both have a numeric data type.
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 1. Specifies the name of the first 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 whether the values must be within or not within a particular range.
Range. Specifies the value for the range. Select the percent box (%) to indicate that the range is a percentage.
%. Check this box to indicate that the range to compare is a percentage, such as 10%.
Measure 2. Specifies the name of the second measure whose data values comprise the range. 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.
Qualify Same as Measure 1. Select this box to use the same qualification for Measure 2 as you specified for Measure 1. Clear this box and use the Qualify button to specify a different qualification for Measure 2.
Copyright © 2003, 2007, Oracle. All rights reserved.