New Condition Step dialog

Use this dialog to create a condition step as part of working with selection steps.

For more information, see "Working with Selections of Data".

This dialog is also displayed as:

Edit Condition Step dialog

Components

Condition Type

Use to select from a list of condition types for the specified dimension column. The following list describes the categories of condition steps that you can create. The components in this dialog differ slightly, depending on which type you select.

Exception — Conditions that select members using comparisons of values for measure columns. 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 column. 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."
Match — Conditions that select members based on matches with text strings and attribute values. A sample condition is "Name contains abc." You can use this condition only with columns that have a string data type.
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." Available only for columns with a data type that relates to time.

Action

Use this box to select the type of action to create for the members that the condition step specifies. You can select to add the selected members to the selection, keep only the selected members and remove all others, or remove the selected members from the selection.

Use the box beside the action type to select the column for whose members you are creating the condition step.

Column

Use this box to select the attribute column on which to base the condition, when created condition steps of the type Match, All X Values where Y = values.

Operator

Use this area to select the operator, based on the type:

For Exception, depends on the type. Sample values include Within, Not Within, Between, Greater than, and Equals.
For Top/Bottom, whether the members have a ranking of top or bottom.
For Time/Ordinal, either:
- Whether to use the last or first number of time periods, using the value in the Number field.
- Whether the members start with, end with, or come before or after the column value in the Time Period field.
For Match, whether the members contain, begin with, end with, or match the string in the Text field.

Number

Enter the number of time periods, such as 3, when creating condition steps of type Time/Ordinal.

Time Period

Select the column value on which to base the condition, when creating condition steps of type Time/Ordinal.

Rank or Range

Enter the percentage to use for the rank or range, such as 5, when creating condition steps of type Exception or Top/Bottom.

Value

Enter the value to use for the comparison, when creating condition steps of type Exception.

Text

Enter the string to use for matching with the members, when creating condition steps of type Match. Select Match Case to provide case-sensitivity for the matching.

Override with

Use this box to specify that an analysis prompt, a dashboard prompt, or a variable can override the values that you specify in this condition step. Depending on what you are overriding, you can override certain values with a prompt, a presentation variable, a session variable, or a repository variable.

If you select a variable type, then enter the name of the variable in the field. For example, suppose that you have a column called EMPLOYEE_ID. You can specify USER as the session variable with which to override the value of that column. When a user logs in, the column value is set to his login name. For more information on variables, see "Using Variables".

In a list of steps for a column, specify that only one step in the list be able to be overridden by a prompt or presentation variable.

For information, see Chapter 6, "Prompting in Dashboards and Analyses."

Measure

Use this list to select the name of the measure column whose data values you want to compare, when creating condition steps of type Exception or Top/Bottom.

For

Use this area to qualify all of the dimensions of the analysis other than the dimension whose members you want to select, when creating condition steps of type Exception or Top/Bottom. For each dimension, you select which of its members to include. You can select specific members, or All, which specifies to aggregate the members when creating the condition. For example, suppose that you are qualifying the Region dimension. You can select a specific region, such as East, whose value is used in the condition. If you select All, then the values of all regions are aggregated and used in the condition.

You can use the For area to create a qualified data reference (QDR). A QDR is a qualifier that limits one or more of the dimensions to retrieve a single value for a measure column. A QDR is useful when you want to temporarily reference a measure column value without affecting the current status of the dimensions. The following is an example of a QDR:

Add members of Total Products (Rgd Sk Lvl) where "A - Sample Sales"."Base Facts"."1- Revenue", For: Cust Segments Hier: 'Active Singles', 'Baby Boomers' is greater than "A - Sample Sales"."Base Facts"."1- Revenue", For: Cust Segments"

When you specify a QDR, you can specify multiple members for limiting the dimensions. When you specify multiple members, the measure column value is aggregated using the default aggregation from the Oracle BI Server. For example, suppose that you want to create a condition for displaying those Regions in which Units is greater than 100. Suppose that you create a QDR for the Year dimension that specifies 2000 and 2001 and that the default aggregation is Sum. If the values for 2000 and 2001 for the Central region are 50 and 60 respectively, then both those years are displayed, because their sum exceeds the 100 units that was indicated.

Offset

Use this list to select either addition or subtraction, to enter the number and to specify whether the number is a percent, when creating certain condition steps of type Exception.

Match in

Use this box to select the part of the member to match when creating condition steps of type Match. Options include any label, member ID, long label, medium label, and short label.

Note

To create a step that is based on a hierarchy, use the "New Hierarchy Selection Step dialog".