Creating a Query and Including Exceptions

1. In BW Query Designer in SAP HANA Studio, choose the Exceptions tab.

2. Right-click in the Exceptions screen area to open the context menu, and choose New Exception.

3. On the Exception Properties screen, create the exception definition.

On the General tab of the Exception Properties screen, set the description, the default status, and one or more exception values.

Select Exception is Active to set the exception’s default status, as shown above. When this option is selected, the exception is applied as soon as you execute the query.

Use exceptions to evaluate one or all key figures in your query definition. To use exceptions on specific key figures in your query definition, you must define an exception for each key figure in question.

You can set nine different alert levels using the colors red, yellow, and green. There are three shades of each color, with the rank of exceptions ranging from 1 for Good 1 to 9 for Bad 3:

• Red: Bad 1, 2 and 3

• Yellow: Critical 1, 2 and 3

• Green: Good 1, 2 and 3

The nine different alert levels are assigned to the SAPExceptionLevel1 … 9 styles in SAP Analysis for Microsoft Office. You can change the exception styles, for example, font and background color in the Home tab of Microsoft Excel:

1. Open the context menu of the selected style in the ribbon and choose Modify.

2. Save style changes by saving the Analysis workbook.

3. Save colors as a style set.

4. Apply other style sets by choosing the Analysis tab and selecting Styles.

You can include all values or specific intervals, for example, only those falling below the threshold value in the red area, in the threshold value catalog.

When key figure values are on the border between two alert levels, the highest alert level rank is used. An example of this is when there is an alert level of Between 0 and 1000, using Bad 3, and another alert level of Between 1000 and 5000, using Critical 3, and the key figure being evaluated has a value of 1000. The key figure value of 1000 is the common point between the two alert level ranges. In this case, the value will be assigned the color used for Bad 3 because it has a higher alert level rank.

On the Definition tab of the Exception Properties screen, configure the exception so that you can:

• Evaluate the exception against one or all of the key figure elements in a key figures structure and/or against the elements in one or two characteristic structures. Remember: A query can have a maximum of two structures, either one key figure structure and one characteristic structure, or two characteristic structures.

• Determine whether the exception is evaluated before or after any local calculations.

• In the Is Displayed in Data Cells / Characteristic Cells screen area, control the cells in your report that will receive color for an alert level.

On the Cell Restrictions tab of the Exception Properties screen, specify whether the exception applies to both detail and result values, or to detail values only, or to the result values only.

In the Cell Restrictions section, choose Add to define an operator for each characteristic in the query definition, and a value in case of the operators Fixed Value and Level.

In the Standard operator for all characteristics not listed field, you specify whether the exception should affect all rows or only result rows in the characteristics that you have not defined a restriction for in the lower screen area.

The following table presents the results for available cell restrictions operators and shows the corresponding operators in SAP Business Objects Analysis: