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

Performing On-Report Analysis with Web Intelligence 211
(Year; Quarter). Therefore, you can remove Quarter from the input context by specifying
ForAll ([Quarter]) in the formula, which looks like this:
Sum([Sales Revenue] ForAll ([Quarter]))
Note that you can use the In operator to achieve the same thing; in this case the formula
is:
Sum([Sales Revenue] In ([Year]))
This version of the formula explicitly specifies Year as the context, rather than removing
Quarter to leave Year.
The ForAll and ForEach operators are useful when you have a default context with many
dimensions. It is often easier to “add” or “subtract” from the context using ForAll and
ForEach than it is to specify the list explicitly using In.
Extended syntax keywords
Extended syntax keywords are a form of “shorthand” that allows you to refer to dimensions
in extended syntax without specifying those dimensions explicitly. This helps future-proof
reports; if formulas do not contain hard-coded references to dimensions, they will continue
to work even if dimensions are added to or removed from a report.
There are five extended syntax keywords: Report, Section, Break, Block and Body.
The following sections describe each keyword, with an example to illustrate each. The
section ”Using keywords to make reports generic” on page 216 illustrates the way in
which the use of keywords makes reports generic.
The Report keyword
The following table describes the data referenced by the Report keyword depending on
where it is placed in a report:
Example: The Report keyword
When placed in... References this data...
A block All data in the report
A block break (header or footer) All data in the report
A section (header, footer, or outside a
block)
All data in the report
Outside any blocks or sections in the report All data in the report