Create Exception

Use

An exception is a condition which determines when a value is to be regarded as worth taking note of in either a positive or a negative sense. When the value exceeds a predefined maximum threshold or falls below a predefined minimum threshold, the system displays it in a different color. You define these threshold values using the function Create exception. You can define as many exceptions in a report as you want.

Procedure

  1. Execute a report.
  2. Position the cursor on the value column for which you would like to define threshold values. The exception will depend on either the individual column or the column group, depending on whether you positioned the cursor on the column header or on the header of a group of columns. If you position the cursor on a row, you can define an exception for a certain characteristic value of the characteristic displayed.
  3. Choose Extras ® Create exception.
  4. In the dialog box, click on the desired range of validity. Choose Column if you want to define the exception for one column in all the lists of the report. Choose Cell if you want to define it for one cell or all the cells of one column of one list. Press Continue.
  5. In the next dialog box you can enter a description for the exception. The system displays the range of validity you chose. If you want the exception to apply for all the characteristic values in the column, enter *.
  6. In the next dialog box, you can define the thresholds and colors for the exceptions. You can define either one or two thresholds. Enter a value for the desired threshold(s) and set the threshold(s) to active. Choose the desired color. If you do not want to define one of the thresholds, make sure that it is not active. The following different combinations are possible: two red ranges, two green ranges, one red and one green range, or either one red or one green range.

Result

When you return to the report list, the system highlights those values that fulfill the conditions specified in the exception rule.

You can only create exceptions from the drilldown list of a report. However, you can change or display them from the detail list as well.

See also:

Editing Exceptions

Overview: Exception Reporting