List of Exceptions
The List of Exceptions design item lists all exceptions defined in the query and lets you activate and deactivate them with the context menu or with an icon.
If exceptions have been defined in the query, you can use the list of exceptions design item to display them in rows in the worksheet. The description of each exception appears in a cell, and its status (Active or Inactive) and an icon (Activate / Deactivate) displays in the cell next to it.
In analysis mode, click the icon to toggle the active status or evoke the context menu and choose:
- Activate to activate a selected inactive exception
- Deactivate to deactivate a selected active exception
Exceptions specify the background color of data cells in results and draw your attention to exceptional values. When you activate or deactivate an exception, the background color of the corresponding data cells in the analysis grid is refreshed accordingly.
Configure properties for the list of exceptions design item using the Properties of List of Exceptions dialog box (seeInserting Design Items to learn about how to insert the list of exceptions and access its properties).
Properties of List of Exceptions
| Property | Description |
|---|---|
|
Name of List of Exceptions |
Displays the name of the list of exceptions, which is generated automatically and is unique. This name is used on the BEx Analyzer → Design Toolbar menu to refer to a particular instance of the list of exceptions. |
|
Data Providers |
Assign an existing data provider to the list of exceptions, create and assign a new one, or change or delete a data provider. The initial view of a data provider corresponds to the query view. |
|
Range |
Manipulate coordinates for a cell or cells in this field to move or resize the list of exceptions. |
More Information: