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 297
Building the condition for the alerter using the formula language
To build the formula for an alerter, you need to include the following elements:
[<object_name>]<operator>"<value>"
Notice that the object name separators before and after the object name are [ ] and
that there are quote marks before and after the value.
For example, to specify a condition that will activate the alerter, if sales revenue results are
lower than $50K, type the following formula:
[Sales revenue]<"50000"
You can include multiple conditions. For example, an alerter with two conditions is
structured like this:
([<object_name>]<operator>"<value>") And ([<object_name>]<operator>"<value>")
Creating alerters that display strings in cells where values meet the alerter
condition(s)
If you want the alerter to display a character string or date string in cells that meet the
condition of the alerter, do not try to use the IF function for this purpose. If you want to an
alerter to display a specific string on report cells, where the results meet the condition in
the alerter, you need to use the formula pane on the
Alerter Display dialog box. (See
”Using the formula language to display a text or formula” on page 302.)
If you use the IF function to create a boolean condition, the alerter is only applied
correctly, when you use numerical values in the condition. For example, the following
condition includes the numerical values “1” and “0”:
If [Sales revenue] > 300000;1;0
This will apply the alerter to all sales revenue results greater than $300K.
However, if you use a character or date string in the condition, the alerter is not applied.
This is because, according to boolean logic, 1 or numbers greater than 1 are true, but
numbers less than 1 (or character or date strings, such as “True” or 15 May 2004), are
false. For example, the following condition includes the strings “High” and “Low”:
If [Sales revenue] > 300000;"High";"Low"
This will not apply the alerter to any results on the report.
The following example shows how to use the formula pane in the Alerter Display dialog
box, to display a string in the report cells where results meet the condition(s) in an alerter.
Example: Flag high-selling product lines with a “high performer” tag