Use this dialog box to select members based on ranking within a measure, such as top 5 or bottom 3.
Action
Specifies whether to add, keep, or remove the members that are selected in this step.
Level
Specifies the particular hierarchy level for the dimension from which to select members.
Meeting Condition
Specifies information about the condition that the data must meet.
Operator. Specifies whether the members have a ranking of top, bottom, or top or bottom.
Rank. Specifies the value for the rank. Select the percent box (%) to indicate that the rank is a percentage.
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. Qualifies the other dimensions by identifying a single member to be used in the calculation.
Qualify. Displays the Qualify Measure dialog box, which you use to change the selected dimension members in the For box.
Copyright © 2003, 2007, Oracle. All rights reserved.