Exception Reporting

In exception reporting, you select and highlight objects that are in some way different or critical. Results that fall outside the set of predetermined threshold values (exceptions) are highlighted in color or marked with icons. This allows 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.

You can define exceptions in the following area of the Business Explorer:

• in the BEx Query Designer (seeDefining Exceptions)
• in Web Applications (seeDefining and Changing Exceptions)
  • In the List of Exceptions Web item
  • In the context menu
• in theBEx Web Analyzer

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 with the BEx Broadcaster.

Exception reporting is made up of three functional areas: the exception definition, the online evaluation of exceptions, and the evaluation of exceptions in background processing.

Defining Exceptions

Exceptions for a query that you define in the Query Designer are globally valid for queries in all workbooks and Web applications. Exceptions for a query view that you define in a Web application are globally valid for this query view in all Web applications that are based on the query view.

Defining an exception involves, for example:

• Specifying threshold values or intervals, which are given a priority (bad, critical, good). The priority given to an exception corresponds to preassigned colors that become more 'intense' the greater the deviation. Up to nine different shades of the traffic light colors (red, yellow, and green) are used. As an alternative to displaying exceptions as background colors, in BEx Web Applications, you can also use icons as a means of highlighting them.
• Determining characteristic restrictions. Using characteristic restrictions, you specify the cells to which the exception is to be applied.

For more information, seeDefinition of Exceptions.

Evaluating Exceptions Online

BEx Web Applications

The table cells for which defined exceptions were exceeded or not reached are displayed in color or with icons. Furthermore, you can display exceptions in maps and charts. For more information, seeDisplaying Exceptions in Maps and Charts.

TheList of Exceptions Web item allows you to list exceptions with their status (active or inactive). You can then activate or deactivate exceptions, create new exceptions, or change existing exceptions.

BEx Analyzer

The cell areas of the table of an executed query for which the defined exceptions were exceeded or not reached are highlighted in color according to the definition.

TheList of Exceptions design item allows you to list exceptions with their status (active/inactive) and to activate or deactivate them.

Evaluating Exceptions in the Background

With the BEx Broadcaster, you can check queries for exceptions in the background. If a threshold value for an exception is exceeded or not reached, the BEx Broadcaster immediately generates a document according to the criteria you defined and distributes this to the recipients by e-mail, to the portal, or as an alert.

For more information, seeBroadcasting Queries by Exception.