HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Building Reports Using the Web Intelligence Java Report Panel 295
4. To close the Alerters dialog box, click OK.
The alerter is removed from the document.
Using formulas to create advanced alerters
You can build advanced alerters using the Web Intelligence formula language. This is
useful if you want to include formulas within the definition of the alerter.
Example: Highlighting three ranges of quarterly sales revenue results calculated as
percentages of the average sales revenue
In this example, you build three alerters to color-code sales revenues, depending on their
relationship to the average sales revenue. The table includes results for three years, and
this is the average to which you want to compare each sales revenue result calculated per
quarter per product line.
Using the Formula option in the Alerter Editor, you build the following alerter, which
contains three sub-alerters.
Each sub-alerter has a single condition. Web Intelligence combines the sub-alerters with
the Or operator, as follows:
[Sales revenue] < ((Average([Sales revenue]) In Block) * 0.8)
Or
=[Sales revenue] < ((Average([Sales revenue]) In Block) * 1.2)
Or
=[Sales revenue] > ((Average([Sales revenue]) In Block) * 1.2)
The formula you specify for each sub-alerter is calculated as follows:
• The first sub-alerter will be activated on sales revenue results that are < 0.8 (this means,
less than 80%) of the average.
• The second sub-alerter will be activated on sales revenue results that are < 1.2 (this
means, less than 120%) of the average.
• The third sub-alerter will be activated on sales revenue results that are > 1.2 (this
means, greater than 120%) of the average.
Notice that the context “In Block” is specified in the formula. This means that the average is
calculated for all of the dimensions included in the table (the generic term used to refer to
a table, chart, or form is block). (For detailed information on how to specify the calculation
context for formulas, see ”Defining the calculation context” on page 314.)
You then use the formula pane in the
Alerter Display dialog box, to specify the conditional
formatting you want displayed on the report cells. Here, you specify an appropriate text
string and format you want displayed, when the results in a table cell meet the condition
for one of the sub-alerters.
You specify the following:
• Report cells containing sales revenue results that are less than 80% of the average
revenue, display the character string in red.