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.
The following list describes the categories of condition examples on the Conditions tab:
Exception -- These conditions return members using comparisons of values for measures. Sample conditions are "Sales > Cost" and "Sales <= Cost + 10%."
Top/Bottom -- These conditions return 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."
Time/Ordinal -- These conditions return members based on ranges of time and on hierarchical levels. A sample condition is "From July 2000 to December 2000."
Hierarchy -- These conditions return members based on hierarchical relationships, such as family members and descendants. A sample condition is "Children of Regions of the World."
Match -- These conditions return members based on matches with text strings and attribute values. A sample condition is "Name contains abc."
To create a condition using an example, complete the following steps:
Click a drill icon beside a condition category to drill in the examples in that category.
Highlight a condition example that is similar to the condition that you want to create.
Click a blue, underscored part of the example and edit it by either typing or by selecting from the available options.
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: A different version of the Edit Step dialog box is displayed, 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 returned by that condition step, as explained in the following list:
Add -- Adds the members that are returned by the condition step to the query.
Remove -- Removes the members that returned by the condition step from the query.
Keep -- Keeps only those members that are returned by the current condition step with the query, if those members were previously included in the query result.