HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Creating Custom Calculations208
formula’s “break” occurs at each year/quarter change, rather than each year change. As
a result, the block is as follows:
In words, this formula tells Web Intelligence to calculate revenues by year, quarter and
month, then output the smallest of these revenues that occurs in each year/quarter
combination”.
Extended syntax context operators
In the examples so far, you specified input and output contexts by using the word In, then
listing the dimensions to be included in the context. In is known as a context operator. The
other context operators are ForEach and ForAll. The following table describes the
context operators:
The In context operator
The In context operator specified dimensions explicitly in a context.
Example: Using In to specify the dimensions in a context
Operator Definition
In Used to specify dimensions explicitly. Also used with
extended syntax keywords (see ”Extended syntax
keywords” on page 211)
ForEach Adds dimensions to the context
ForAll Removes dimensions from the context