EXCEPTIONS AND CONDITIONS
hOW EXCEPTION AND CONDITIONS ARE APPLIED INTHE QUERY DESIGNER.
hoW THIS TWO PROPERTIES ARE IMPORTANT IN THE REPORTING.
Hi ranam ,
Below is the detailed discription on exception and condition :-
You can make restrictions in the Query Designer, using Condition . As a
prerequisite, you have to have created a query definition for which one
or more conditions can be defined.
In the dialog box that appears, you specify a meaningful Description and
set the condition to Active. If the condition has the status Active, that
condition is used in the report as soon as you execute the query. If you do
not set the active flag, you can activate the condition in the report itself.
In the BEx Analyzer, from the BW toolbar Layoutu2192 Display Conditions,
you also have the option of adding an additional line between the filter
and results areas for each condition and activating or deactivating the
condition from there. There is an item for Web applications that you can
integrate into your template for the same purpose.
You can set conditions for all characteristics, single characteristics, and
characteristic combinations in the report drilldown, that is, in the results
area in the BEx Analyzer or in the table item.
Hint: If you restrict conditions for a report to Single Characteristic
or Combinations of Characteristics, you have to ensure that the
characteristic or the combination of characteristics is integrated into
the report drilldown for the restrictions defined to take effect.
The functions in exception reporting enable you to select and highlight
unusual deviations of key figure values in a query. You can see deviations
from predefined threshold values or intervals in the query result displayed
in different colors if the exception is active. Early spotting of these
deviations provides the basis for timely and effective reactions.
398 © 2003 SAP AG. All rights reserved. August 2003
TBW20 Lesson: Exceptions
Figure 96: Defining Exceptions in the Query Designer
You create an exception in the Query Designer using the symbol
Exceptionu2192 New Exception.
In the dialog box that appears, you can specify a meaningful Description
and set the exception to Active. The exception is applied as soon as you
execute the query. If you do not set the active flag, you can activate the
exception in the report itself. In the BEx Analyzer, fromthe BW toolbar,
Layoutu2192Display Exceptions, you also have the option of adding an
additional line between the filter and results areas for each exception and
activating or deactivating the exception from there. There is an item for
Web applications that you can integrate into your template for the same
You can use exceptions to evaluate one or all key figures in your query
definition. If you want to use exceptions selectively on specific key figures
in your query definition, you have to define an exception for each key