Calculation Step Conditions

The Conditions subtab provides examples of the conditions for selecting dimension members. You modify the examples to create the exact condition that you want.

You can use the following conditions:

Hierarchy. Conditions that select members based on hierarchical relationships, such as family members and levels. A sample condition is "Children of 2005."
Match. Conditions that select members based on matches with text strings and attribute values. A sample condition is "Quarter = Q1 ."

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

Click a drill icon (+) beside a condition category to expand the list of examples in that category.
Select a condition example that is similar to the condition that you want to create.
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. When you use an Edit Step dialog box to create a condition, you specify whether to add or remove the selected members from the current condition step.

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