Conditions tab

Use the Conditions tab to select and customize conditions that become steps to narrow the scope of a query. The Conditions tab 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.

Categories of conditions

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

Creating conditions

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

  1. Click a drill icon beside a condition category to drill in the examples in that category.

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

  3. Click a hyperlink within a selected example and edit it by either 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.

Adding, keeping, and removing members

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: