Overview: Exception Reporting

An exception is a condition which defines whether or not a value is worth paying particular attention to. You can create exception rules for any key figure in a cell or a column of a report. These exceptions comprise two threshold values which determine the maximum and minimum values for an acceptable range of variance. If a value for this object surpasses either one of these thresholds, the system displays that value in a different color (red or green).

There are two fundamental types of exceptions. You can define an exception either for a specific cell or for an entire column.

Exceptions for columns

Relative key figures, such as variances, are normally comparable at different drilldown levels of a report. It therefore makes sense to define a single exception for the entire column. This means that the exception is effective for every list of the report and independent of which drilldown level is currently being displayed.

The graphic above shows sales for different countries for the year 1996 and the variance for each of these compared to 1994. For the column % var. 95/96, we define a lower threshold of -5 and an upper threshold of +10, thus defining the interval between -5 and +10 as "normal". In the report, variances greater than +10% are displayed in green, and those below -5 % are displayed in red. Variances between -5% and +10% appear in the normal background color.

When we drill down on the country USA, we see the products sold there, the sales figures for 1996 and the variances. The exception defined in the second column is also evaluated in the second list. That is, the exception is evaluated for both the countries and the individual products.

Exceptions for cells

The second type of exception applies only to a single cell and therefore makes sense to use with absolute key figures, such as sales.

This graphic shows an exception for the cell USA/Sales 1996 defined with a lower threshold of -1,500,000 and an upper threshold of +2,000,000.

When we drilldown on the country "USA", we see that the exception is not applied to the second list. Since the figures have no relevance for the drilldown characteristic, it would make no sense to apply the exception here.

Since it can be quite time-consuming to define a large number of cell exceptions, there is also a third option. You can define an exception for all the cells of a column which appear in the same list. This exception is only evaluated on the list for which it was created. To define this type of exception, position the cursor on the column header (not on a single cell) and choose the area of validity Cell. Enter * instead of the content of a specific cell.