Bi L3 Bex Query Designer Unit 7

BEx Query Designer

Unit 7: Exceptions and Conditions

7/17/2007

What are Exceptions? Exceptions are deviations from pre-defined threshold values or intervals. Exception reporting enables you to select and highlight unusual deviations of key figure values in a query. Activating an exception displays the deviations in different colors in the query result. Spotting these deviations early provides the basis for timely and effective reactions. Slide 2

Creating Exceptions Creating a new exception Click the Exceptions button and select New Exception. •Description Used to name the exception. •Active Used to toggle display of the exception on/off in the query result.

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.

Slide 3

Exception Values Enter the upper and lower threshold values along with the Alert Level (color) for each exception interval. Leave a threshold value blank to specify an open-ended (infinite) value. By defining variables as threshold values, you can influence defined exceptions flexibly.

Note

You can define several exceptions in a query for different value assignment areas or for different versions. If the threshold value areas overlap when you activate several exceptions, the worst (highest) alert level counts. Slide 4

Cell Restrictions You can specify whether a restriction with regard to the use of the exception applies Only to the Totals or to All values: •Everything The cell context is not restricted. The exception applies for every drilldown state of the characteristic. •Totals Only The exception affects only the aggregated values of the characteristic. Everything Except Totals The exception affects all values except for the aggregated values of the characteristic. •Fixed Value The exception applies only to a specific characteristic value or characteristic value variable of the characteristic. •Level The exception applies only to

Slide 5

Changing and Deleting Exceptions Changing an existing exception Click the Exceptions button, select Change Exception, and click OK. Deleting an existing exception Click the Exceptions button, select Change Exception, and click Delete.

Slide 6

What are Conditions? Conditions are restrictions placed on key figures in order to filter data in the query results. Conditions restrict the data accordingly in the results area of the query so that you only see the data that interests you. You can define multiple conditions for a query, and then activate or deactivate them in the report itself to create different views of the data. Examples: – You can display all key figure values above or below a certain value – Using ranked lists, you can display your ten best customers by sales revenue Slide 7

Creating Conditions Creating a new condition Click the Conditions button and select New Condition. •Description Used to name the condition. •Active Used to toggle display of the condition on/off in the query result.

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.

Slide 8

Defining Conditions Enter the key figure to filter along with the appropriate operator and threshold value for each condition row. By defining variables as threshold values, you can influence defined conditions flexibly. You can use the following operators for threshold value conditions: •Equal to •Not equal to •Less than •Greater than •Less than or equal to •Greater than or equal to •Between •Not between

You can use the following operators for ranked list functions: •Top N •Bottom N •Top %

•Bottom %

•Top Sum

•Bottom Sum Slide 9

Using Several Conditions in a Report If you are using several conditions in one report, conflicts can arise which lead to automatic deactivation. The following status descriptions appear in the display: – Variant Reason: The condition relates to a characteristic or characteristic combination that is not included in the drilldown. – Not Used Reason: The condition relates to a characteristic that is drilled down using an active display hierarchy. The condition relates to a characteristic that is included through the activation of another condition, leading to a collision, and is therefore deactivated (however, you can reactivate this condition and automatically deactivate the last condition activated).

Note

If you activate a condition for a combination of characteristics, the results row is no longer displayed.

Slide 10

Changing and Deleting Conditions Changing an existing condition Click the Conditions button, select Change Condition, and click OK. Deleting an existing condition Click the Conditions button, select Change Condition, and click Delete.

Slide 11