Defining Exceptions

Use

You can define threshold values (exceptions) for a query. Data that varies from these thresholds is highlighted in color or marked with icons. You can use these exceptions to identify deviations from expected results at a glance.

Procedure

Defining and Changing Exceptions

In the Exceptions screen area, choose New Exception in the context menu. An entry with the default text Exception <Number>appears and you can edit the description directly.
In the context menu, choose Edit. The exception editor appears; it displays the relevant parts for the definition on tab pages.

Note

You can also call the exception editor from the Properties screen area by choosing the Edit pushbutton.
Make the required settings for the definition of the exception. For more information, seeDefinition of Exceptions.
Choose OK. You return to the query definition.
Choose Save Query.

Removing Exceptions from Queries

In the Exceptions screen area, select the relevant exception and choose Remove in the context menu.
Choose Save Query.

Result

You have defined or changed an exception for a query. Execute the query. The exception is evaluated online. The cell areas that are affected by the exception appear highlighted in the appropriate color or, where applicable, with icons in Web applications.

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, seeBroadcast by Exception.