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.