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 313
Conditional operators
Conditional operators determine the type of comparison to be made between values. The
following table describes them
:
You use conditional operators in conjunction with If, as in:
If ([Revenue] >= 10000;‘High’;‘Low’)
which returns “High” for all rows where the revenue is greater than or equal to 10000 and
“Low” for all other rows.
Logical operators
Logical operators are used in expressions that return True or False. You use such
expressions in the If function. The Web Intelligence logical operators are AND, OR, NOT,
Between and InList. For example, the expression:
If ([Resort] = ‘Bahamas Beach’ OR [Resort]=’Hawaiian Club’; ‘US’; ‘France’)
returns “US” if the resort is “Bahamas Beach or “Hawiian Club”, “France” otherwise.
The expression:
[Resort] = ‘Bahamas Beach’ OR [Resort]=’Hawaiian Club’
returns True or False, True if the Resort variable is equal to ‘Bahamas Beach’ or ‘Hawaiian
Club’, False otherwise.
Context operators
Context operators form part of extended calculation syntax. Extended syntax allows you to
define which dimensions a measure or formula takes into account in a calculation. It is
described in detail in the section ”Defining the calculation context” on page 314.
Function-specific operators
Some Web Intelligence functions can take specific operators as arguments. For example,
the
Previous() function can take the SELF operator. See the functions on-line help and ”Web
Intelligence functions” on page 337 for more information.
Operator Description
= Equal to
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
!= Not equal to