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 or designated with symbols. 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 Web item List of Exceptions

¡        In the context menu

·        In the BEx 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.

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 for a query that you define in the Query Designer are globally valid for a query 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.

Among other things, 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. As an alternative to displaying the exceptions as background colors, BEx Web Applications offer you the option of using symbols to highlight them.

·        Determining characteristic restrictions. You use the characteristic restrictions to specify the cells that the exception is to affect.

For more information, see Definition of Exceptions.

Evaluating Exceptions Online

BEx Web applications:

The cells of the table for which defined exceptions were exceeded or were not reached are marked in color as such or highlighted with symbols. Furthermore, you can display exceptions in maps and charts. For more information, see Display of Exceptions with Maps and Charts.

The Web item List of Exceptions enables you to list the exceptions available, together with their respective status (active/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 fallen short of are highlighted in color according to the definition.

The design item List of Exceptions enables you to list the exceptions available, together with their respective 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 in accordance with the criteria defined by you and distributes this to the recipients by e-mail, to the portal, or as an alert.

For more information, see Exception-Specific Broadcast.