Properties of the Exception 

Use

In the Properties of the Exception dialog, you can activate or deactivate the exception, change the description and make settings for the properties of the exception.

Features

The Properties of the Exception dialog box is divided into tab pages, each covering different settings.

Tab Page: General

Here you can activate or deactivate the condition with Activate Exception. Under Description, you can change the description of the exception.

Tab Page: Definition

Exception Is Defined for

You define the key figures. The exception is analyzed based on these key figures. The exception can affect all structure elements of a structure or only a selected structure element.

Time of Analysis

You can set whether the analysis of the exception takes place before or after a local calculation. See Local Calculations.

Tab Page: Cell Restriction

Standard Operator

In the cell restriction of the exception, you determine the cells that the exception is to evaluate.

Exception Affects All Values: This setting is especially suitable for relative key figures. Trend exceptions typically affect all values.

Exception Affects Only Results: This setting is especially suitable for absolute key figures. Status exceptions typically affect all results.

Tab Page: Display

You can set whether the exception affects the data cells or the characteristic cells. According to your setting, the highlighting of the exception appears on the numbers for the selected key figure or the text for the most detailed characteristic value.

Presentation on Data Cells

If the exception is to affect data cells, choose active.

When presenting exceptions on the data cells, for each structure of the query, you can choose whether the exception is displayed on the analyzed structure element, on another structure element or on all structure elements.

Presentation on Characteristic Cells

If the exception is to affect characteristic cells for the most detailed characteristic value, choose active.

When you are presenting the exception on the characteristic cells, you can choose whether the exception is displayed on the rows, on the columns or on both the rows and the columns.

Activities

Select the required condition in the Exceptions in the screen area. In the Properties screen area, the properties dialog for the exception appears. You can also select multiple exceptions and set the properties simultaneously. You can use Display/Change  to set whether the properties of the exception can or cannot be changed. You can save your settings with  Save.