Show TOC

 Set ConditionLocate this document in the navigation structure


Using the Set Condition command (SET_CONDITION), you can create or change a local condition.

Command Parameters

The following information outlines the command parameters in the same sequence that they appear in the command wizard when you insert the command:

Parameter Description


Enter a list of all data providers to which the command applies.

You specify the individual data providers in the Data Provided Affected parameter (TARGET_DATA_PROVIDER_REF).

Condition (CONDITION)

Enter the unique ID (UID) for the condition that you want to change. If you want to create a new local condition, enter a new technical description.

Description (DESCRIPTION)

Using the text input dialog , enter a suitable description for the condition.

Active (ACTIVE)

You use this parameter to make the condition active. If you make the condition active, it is automatically used in the Web application when the command is executed.

Characteristic Assignment (DRILL_CONTEXT)


All Characteristics in Drilldown Independent (INDEPENDENT)

If you choose this option, you can use the condition in a general way. Depending on which characteristics you use in the drilldown, you obtain different results. This option is optimized for ranked list conditions, but can also be used for threshold conditions with relative values.

Most Detailed Characteristic Along the Rows (DETAILS_ON_ROWS)

This option is optimized for threshold values. The condition is applied to the most detailed characteristic of the rows.

Most Detailed Characteristic Along the Columns (DETAILS_ON_COLUMNS)

This option is optimized for threshold values. The condition is applied to the most detailed characteristic of the columns.

Single Characteristics and Characteristic Combinations (CHARACTERISTICS)

This option allows you to evaluate the condition for specific drilldowns of defined characteristics or characteristic combinations. You can select any characteristic (of the characteristics used in the query in rows, columns, or in the free characteristics) or a characteristic combination.

To do this, you use the value help dialog for Characteristic to specify the characteristic or the combination of characteristics.

List of Data Cell Conditions (DATA_CELL_CONDITIONS)

A condition always refers to exactly one data cell. The structure component (character string with 25 characters) must be specified for all structures that exist (maximum of 2): using this parameter, you can specify a list of data cell conditions. Additional parameters must also be set for each entry in the list. For more information, see the following table.

You must set the following parameters for each entry in the list of data cell conditions:

Parameter Description

Data Cell (DATA_CELL)

You use this parameter to specify the data cell. You do this by specifying the relevant structure element for each query in the structure. You select the structure in the Characteristic parameter (CHARACTERISTIC). You enter the structure element in the Member Name parameter (MEMBER_NAME).

Data Cell Condition Operation (DATA_CELL_CONDITION_OPERATION)


You use this parameter to specify the operator of the condition and a value appropriate for the operator. You have the following options:

Equal To (EQUAL)

Not Equal To (NOT_EQUAL)

Between (BETWEEN)

Not Between (NOT_BETWEEN)

Greater Than (GREATER_THAN)

Greater Than or Equal To (GREATER_EQUAL)

Less Than (LESS_THAN)

Less Than or Equal To (LESS_EQUAL)

The values of these operators must be floating point numbers. For the operators Between and Not Between, you must enter a value range, that is, upper and lower threshold values. To do this, you use the parameters Low Value (LOW_VALUE) and High Value (HIGH_VALUE).

You can choose from the following operators for ranked list conditions:



Top Total (TOP_SUM)

Bottom Total (BOTTOM_SUM)



For Top N and Bottom N, you must enter a whole, positive number as the value. For Top % and Bottom %, you must enter a number between 0 and 100. For Top Total and Bottom Total, you can also enter a floating point number (for example, 15.7).