[quote style=”boxed”]How do you highlight unusual deviations of key figure values in a SAP BW BEx Query? This question is often asked by concerned managers, marketing and sales people who want to spot these deviations as early as possible so they can act fast to changes in their business. One technique is by creating Exceptions in the SAP BW Query Designer.[/quote]Exceptions are used to identify deviations from pre-defined threshold values or intervals. Any data in your BW query that varies from these thresholds are marked with different colors in the query result. That way you can spot any extraordinary variations from expected results straightaway.
Step By Step – Creation Of Exceptions
Log in to query designer and choose the query for which you want to create the exception and click on the Exceptions button
followed by New Exception.
 SAP BW - Query Designer |
 SAP BW - New Exception |
Press the Edit button in the properties area on the right of the window. The properties screen of the exception will then appear.