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 can define exceptions in the following area of the Business Explorer:
· in the BEx Query Designer (see Defining Exceptions)
· in Web Applications (see Defining and Changing Exceptions)
¡ in the Ad-hoc Query Designer
¡ in the Web item List of Exceptions
¡ in the toolbar of the standard Web template
You can evaluate the exceptions online when executing the query or the Web application.
If you want to evaluate exceptions for a large number of queries, you can do this in the background. You schedule the exceptions in the Administrator Workbench Reporting Agent for background processing.
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.
Defining Exceptions
Exceptions are valid globally for a query in all workbooks or in all Web applications.
The definition of an exception consists of:
· Determining threshold values or intervals that are given a priority (bad, critical, good). The priority given to an exception corresponds to pre-assigned colors that become more ‘intense’ the greater the deviation. Up to 9 different shades of the traffic light colors red, yellow, and green are used. These traffic light colors are also used in the alert monitor to display the results of exception reporting. See also Displaying Exceptions: Alert Monitor
· Determining cell restrictions. You use the cell restrictions to specify for which evaluation (cell area) you want the exception to apply.
See also:
Defining Exceptions in the query designer or Defining and Changing Exceptions in Web applications.
Evaluating exceptions online
BEx Web applications:
The cell areas for a table are highlighted in color if they contain values that do not fall within the exceptions you defined previously. Furthermore, you can display exceptions in maps and charts. You can find addtional information under Display of Exceptions with Maps and Charts.
The Web item List of Exceptions enables you to list the exceptions available for a query view with their respective status (active/inactive) listed. You can then activate or deactivate exceptions, create new exceptions, or change existing exceptions.
BEx Analyzer
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.
Note that the evaluation of exceptions always comes from the original values specified by the OLAP processor. Scaling factors and local calculations are not considered with the evaluation of exceptions.
Evaluating exceptions in the background
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 BEx Analyzer toolbar Open dialog box
· Web applications in the alert monitor Web item.
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:
Reporting
AgentDisplaying Exceptions: Alert Monitor