Condition Properties
Use
In the Condition Properties dialog box, you can activate or deactivate the condition, change the description, and make settings for the characteristic assignment.
Features
The Condition Properties dialog box is divided into tab pages, each of which provides different settings.
Tab Page: General
Here you can activate or deactivate the condition using the Condition Is Active checkbox.
Under Description, you can change the description of the condition.
Click Edit… to open the condition editor, where you can change the condition.
Tab Page: Characteristic Assignment
You can choose the following setting options:
â— All Characteristics in the Drilldown Independently
This setting allows you to apply a condition in a general way. Depending on which characteristics you use in the drilldown, you obtain different results.
Characteristics that are already used in an active condition for characteristic combinations are not included.
For more information, see Ranked List Condition: Top 5 Products and Ranked List Condition for All Characteristics in Drilldown Independent: Top 3 Products and Top 3 Sales Channels.
This option is optimized for ranked list conditions, but can also be used for threshold value conditions with relative values.
â— Most Detailed Characteristic Along the Rows
This option is optimized for threshold value conditions. The condition is applied to the most detailed characteristic of the rows.
â— Most Detailed Characteristic Along the Columns
This option is optimized for threshold value conditions. The condition is applied to the most detailed characteristic of the columns.
â— Individual Characteristics and Characteristic Combinations
This setting allows you to evaluate the condition for characteristics or characteristic combinations defined for specific drilldowns only. You can select any characteristic (of the characteristics used in the query in Rows, Columns, or Free Characteristics) or a characteristic combination.
â—‹ If you only want to evaluate the condition when a certain characteristic is present in the drilldown, select this characteristic.
â—‹ If you want to evaluate the condition for characteristic combinations, select multiple characteristics. For more information, see Ranked List Condition for Characteristic Combination: Top 10 Combinations of Product and Sales Channel.
Activities
Select the required condition in the Conditions screen area. The properties dialog box for the condition is displayed in the Properties screen area. You can also select multiple conditions and set the properties simultaneously. If you enter an invalid value, a warning is displayed beside the property and a corresponding text that helps you to resolve the error is displayed in the Messages screen area. You save your settings by choosing Query → Save.
Exception Properties
Use
In the Exception Properties dialog box, you can activate or deactivate the exception, change the description, and make settings for the properties of the exception.
Features
The Exception Properties dialog box is divided into tab pages, each of which provides different settings.
Tab Page: General
Here you can activate or deactivate the condition by using the Exception Is Active checkbox. Under Description, you can change the description of the exception.
Click Edit… to open the exception editor, where you can change the exception.
Tab Page: Definition
Exception Is Defined On
You specify which key figures the exception is to affect. The exception can affect all structure elements of a structure or a selected structure element.
Time of Evaluation
You can set whether the evaluation of the exception is to take place before or after a local calculation. More information: Local Calculations
Tab Page: Cell Restrictions
Standard Operator
In the cell restriction of the exception, you define the cells for which the exception is to be evaluated.
Exception Affects All Values: This setting is especially suitable for relative key figures. Trend exceptions typically affect all values.
Exception Only Affects Results: This setting is especially suitable for absolute key figures. Status exceptions typically only affect results.
Tab Page: Display
You can set whether the exception is to affect data cells or characteristic cells. In accordance with your setting, the highlighting for the exception is displayed on the numbers for the selected key figure or the text for the most detailed characteristic value.
Data Cells
If the exception is to affect data cells, choose Exception Affects Data Cells.
Key Figures
When presenting exceptions on the data cells, you can define, for each structure of the query, whether the exception is displayed on the evaluated structure element, on all structure elements, or on another structure element that you can specify here.
Characteristic Cells
If the exception is to affect characteristic cells for the most detailed characteristic value, choose Exception Affects Characteristic Cells.
When you display the exception on characteristic cells, you can choose whether the exception is to be displayed on the rows, on the columns, or on both the rows and columns.
Activities
Select the required exception in the Exceptions screen area. The properties dialog box for the exception appears in the Properties screen area. You can also select multiple exceptions and set the properties simultaneously. If you enter an invalid value, a warning is displayed beside the property and a corresponding text that helps you to resolve the error is displayed in the Messages screen area. You save your settings by choosing Query → Save.