Exception Reporting 
Exception Reporting
Use
In exception reporting you select and highlight objects that are in some way different or critical. Results that fall outside a set of predetermined threshold values (exceptions) are highlighted in color. This enables you to identify immediately any results that deviate from the expected results.
Exception reporting allows you to determine the objects that are critical for a query, both online, and in background processing.
Integration
You define exceptions in the Query Designer, and evaluate them online when you execute a query. If you want to evaluate exceptions for a large number of queries, this is done in the background. These exceptions are scheduled for background processing in the Reporting Agent of the Administrator Workbench.
Prerequisites
You have defined a query which you want to use for exception reporting.
Features
Exception reporting is made up of three functional areas: The exception definition, the online evaluation of exceptions, and the evaluation of exceptions in background processes.
Exceptions are defined in the Query Designer and are valid globally for a particular query in all workbooks.
The definition of an exception consists of:
See also:
The cell areas in the results area of an executed query are highlighted in color if they contain values that do not fall within the exceptions you defined previously.
Settings that you make in the Reporting Agent are processed in the background. The result is displayed in the alert monitor, and logged in the exception log. If exceptions do occur, it is possible to trigger a follow-up action in the Reporting Agent (a mail is sent to the person responsible, for example).
The alert monitor is a component of the Business Explorer. It is available in:
The number of exceptions that occur is displayed according to the selection of traffic light colors. You can specify that the system run an authorization check before displaying the exceptions. The exceptions are displayed in a hierarchy with the following levels: InfoArea, InfoProvider, query, view, and exception.
See also:
Defining the Exceptions Setting
Displaying Exceptions: Alert Monitor