You can define threshold values (exceptions) for a query. You define exceptions in BEx Query Designer or in BEx Web applications.
Defining an exception involves defining the following components:
Exception Type
You specify whether you want to define a status exception or a trend exception. The type of exception affects how it is displayed.
You can only make this setting in the Exception Wizard, not in the Exception Editor.
Definition of Key Figures
You specify which key figures the exception is to affect. The exception can affect all structure elements of a structure or a selected structure element.
The exceptions in the query that is run can only take effect if the key figure specified here is contained in the drilldown.
If say you define an exception on a key figure K1 (Billed Quantity for example), that affects key figure K2 (Net Sales for example), it is not enough if just K2 is in the drilldown. The exception can only take effect if K1 is in the drilldown as well.
If a structure element is used in the definition of an exception and the structure is inconsistent, the system displays an information message in the Messages area and automatically corrects the structure. The system adds the used structure element to the structure. To activate this change, you must save the structure.
Time of Evaluation
You can set whether the evaluation of the exception is to take place before or after a local calculation. Choose Before Local Calculation or After Local Calculation as required.More information:Local Calculations
Specifying the Threshold Values
Set the required alert level and specify the relevant threshold values and operators.
You can choose from the following alert levels:
You can choose from the following operators:
The values for these operators must be floating point numbers. For the operators [] Betweenand ][ Not Between, you have to enter a value range, meaning an upper threshold value and a lower threshold value.
The input format depends on the country setting for the operating system.
You can use the following convention to simplify handling numbers with multiple zeros:
One apostrophe after the number denotes multiplied by one thousand, two apostrophes denote multiplied by one million, and three apostrophes denote multiplied by one billion. 1.5'' = 1.5 mil = 1,500,000 for example.
The system processes the defined alert level and the associated threshold values sequentially. If you define multiple alert levels and threshold values for a value, the system displays the lowest alert level.
Display/Target
You can define whether the exception affects data cells or characteristic cells. In accordance with your setting, the highlighting for the exception is displayed on the numbers for the selected key figure or the text for the most detailed characteristic value.
When you display the exception on data cells, you can choose whether the exception is to be displayed on the evaluated structure element, on another structure element, or on all structure elements.
When you display the exception on characteristic cells, you can choose whether the exception is to be displayed on the rows, on the columns, or on both the rows and columns.
Table Display
You have the following options for displaying the exception in the table:
In BEx Analyzer, you can only use the background color of the cell to display exceptions. If you want to assign your own colors, choose Workbook Settings on the design toolbar in BEx Analyzer (seeSpecifying Settings for Workbooks).
In BEx Web applications, you can display exceptions using the background color of the cell and the icons option. The background colors are set in the portal theme (seeUnderstanding Portal Themes). The icons are stored in the MIME Repository.
You can only make this setting in the Exception Wizard on the Web. You cannot do this in the Exception Editor in BEx Query Designer.
Characteristic Restriction/Cell Restriction
In the characteristic restriction of the exception, you specify which cells to evaluate the exception on. In the case of status exceptions, the exception only affects the results unless you define otherwise. If there are any trend exceptions, the cell context is irrelevant. The validity area Everything applies here (see table below).
You can choose from any of the free characteristics, or characteristics from the rows and columns used in a query. You cannot use characteristics that are already used in another restriction row in the list.
Select the required validity areas for the characteristics and restrict the characteristics as required.
Possible Validity Areas
Validity Area | Meaning |
---|---|
All |
The validity area is not restricted. The exception is valid for all drilldown states for the characteristic. |
Totals Only |
The exception is valid for aggregated values of the characteristic only. |
Everything Except Totals |
The exception applies to all values of the characteristic apart from aggregated values. |
Fixed Values |
The exception is valid for just one particular value of the characteristic (for example Spare Parts under Product Group). Select the required characteristic value. |
Level |
The exception is valid for a particular hierarchy level of the characteristic only. Select the required hierarchy level. |
Properties
Specify whether the exception is active or inactive and enter a description for the condition.
BEx Query Designer
In Exceptions, choose New Exception from the context menu. An entry with the default text Exception <Number> appears, allowing you to edit the description directly. Choose Edit from the context menu. The exception editor appears. This displays the relevant parts for the definition on tab pages.
BEx Web Applications
You have the following options:
The Exception Wizard appears and provides step-by-step instructions for defining the exception.
BEx Web Analyzer
You have the following options:
The Exception Wizard appears.