Use the Exception tool to select dimension values based on the values of a measure that uses the dimension. For example, you might select cities whose Sales values are greater than $1,000,000.
You can also use the Exception tool to base a selection on the comparison of two different measures. For example, you might select the products whose Sales were more than 5 percent above Forecast.
Note: The search for exception values is restricted to one dimension value for each of the other dimensions of the specified measure.
To select values using the Exception tool:In the Selector dialog box, choose the Exception tool from the Selector toolbar.
Complete the Select by Exception dialog box.
Choose OK.
Copyright © 1984, 2005, Oracle. All rights reserved.