EXCEPTIONS AND CONDITIONS

[Former Member]

hi EXPETS,

hOW EXCEPTION AND CONDITIONS ARE APPLIED INTHE QUERY DESIGNER.

hoW THIS TWO PROPERTIES ARE IMPORTANT IN THE REPORTING.

[Former Member · Accepted solution]

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.

Exceptions

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

Creating Exceptions

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

purpose.

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

figure accordingly.

Thanks