Conditions subtab

Use the Conditions subtab on the Dimensions tab to select and customize conditions that narrow the scope of a query. The Conditions subtab provides examples of various types of conditions. You modify the examples to create the exact condition that you want for a step in a query.

The following list describes the categories of condition examples on the Conditions tab:

• Exception. Conditions that select members using comparisons of values in measures. Sample conditions are "Sales > Cost" and "Sales <= Cost + 10%."

• Top/Bottom. Conditions that select the specified number of members after ranking the members by the specified measure. You can specify an exact number of members or a percentage of the total members. Sample conditions are "Top 10 based on Sales" and "Top 5% based on Cost."

• Hierarchy. Conditions that select members based on hierarchical relationships, such as family members and levels. A sample condition is "Children of Regions of the World."

• Time/Ordinal. Conditions that select members based on ranges of time and on hierarchical levels. A sample condition is "From July 2000 to December 2000."

• Match. Conditions that select members based on matches with text strings and attribute values. A sample condition is "Name contains abc."

To create a condition by using an example, complete the following steps:

1. Click a drill icon (+) beside a condition category to expand the list of examples in that category.

2. Select a condition example that is similar to the condition that you want to create.

3. Click a link within a selected example and edit it either by typing or by selecting from the available options. One option can be More, which displays one of the following dialog boxes: Select Hierarchy/Levels, Select Measure, or Select Member. You can often use the Select Hierarchy/Levels and Select Member dialog boxes to select multiple items.

   or

   Click the Edit Step button to the far right of the example and change parts of the condition using the options in the Edit Step dialog box for that type of condition.

   Tip: The contents of the Edit Step dialog box vary, depending on the kind of condition that you are creating.

When you use an Edit Step dialog box to create a condition, you specify whether to add, keep, or remove the members that are selected by that condition step, as explained in the following list:

• Add. Adds to the query the members that are selected by the current condition step.

• Keep. Keeps in the query only the members that are selected by the current condition step, if those members were previously included in the query result.

• Remove. Removes from the query the members that are selected by the current condition step.

Related Topics

Viewing Measures

Copyright © 2003, 2007, Oracle. All rights reserved.