Alert Level in Microsoft Office

Maker Code-39 in Microsoft Office Alert Level

Description and Functionality The option Exception Affects Data Cells has the follow settings: Evaluate Structure Elements The default on the Definition tab is used against the color levels. All Structure Elements All structure elements will receive the color assigned to the alert levels. Following Structure Elements You can evaluate one structure element but apply the color of the alert to a different structure element. The alert level is assigned to the characteristic values in the rows, columns, or both, where the exception occurs. You can specify whether the exception applies to both detail and result values or to only the result values. This is used for any characteristic that is not in the Define Cell Restriction section. Choose New to define an operator for each characteristic in the query definition and a value for each operator. The settings are Everything, Totals Only, Everything Except Totals, and Fixed Values. Here you can filter the exception to a specific cell in the query. Values assigns a specific value of the characteristic to which you want the exception to be applied.

Characteristic Cells Exception After Characteristic Cells Rows, Columns, Rows and Columns Cell Restrictions (The New, Delete, and Transfer buttons are used to assign the exception values.) Standard Operator for All Characteristics That Are Not Listed

TABLE 6-11 Settings for Exception Definition in the BEx Query Designer (continued)

Symbol The exception is displayed as a symbol. Symbol and Value The exception is displayed with a symbol and the value of the data cell or characteristic cell. Value and Symbol The exception is displayed with a value and the symbol of the data cell or characteristic cell. The following illustration shows the view of the properties of the exceptions. In the General tab, we have identified three levels for exceptions Bad 3, Critical 3, and Good 1 and we have used the between operator to identify ranges of values for the use of the exceptions. The basic

6:

process is to use the New button to open up a line at the bottom of the dialog box to enter information. Then choose Transfer to send your settings to the screen. Use the same process until all your settings are complete.

The additional information for the creation of the Exception includes the Definition Tab. In the Definition tab, shown below, we have decided to filter to the key figure Sales Volume EUR, and none of the other options have been chosen.

Next we go to the BEx Analyzer to execute this process and see the results. The following illustration shows the query executed and the three exception levels displayed. As you can

see, the values are in the three color ranges, and we need to go back into the exception process and remove the exception from the results row.

We now go back into the exception configuration and set up a variable to offer the business user additional flexibility in determining the exception levels at time of execution. The first of the following illustrations shows the initial step in changing the exception. From the Change Exception dialog box, click to the variable button and use the New Variable option to start the setup. We define the variable as Manual Input and provide a technical name and text, as shown in the second illustration. The end result is that upon execution, the variables for the From and To values are offered as manual entries. This allows the business user to adjust their ranges for Bad, Critical, and Good as the year goes on or at the beginning of each year. The final illustration shows the initial pop-up for the variables upon execution of the query.