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

Creating custom calculations332
tells Web Intelligence to remove Year and Quarter from the output context; in other
words, to calculate a grand total, because there are no other dimensions in the report.
(See ”The ForAll context operator” on page 325 for an explanation of ForAll.) The formula
then divides each revenue by the grand total to give its percentage of the total.
Although you can use ForAll in this situation, it is much better to use the Report keyword.
Why? What if the Month dimension were subsequently added to the report? The version
of the formula that uses the Report keyword still calculates each percentage correctly, but
the version that explicitly specifies the Year and Quarter dimensions is now wrong:
Why is this? The problem lies in:
Sum ([Sales Revenue] ForAll ([Year];[Quarter))
When Year and Quarter were the only dimensions in the report, this was equivalent to
“a grand total of all revenues”. Once you add the Month dimension, this expression
removes Year and Quarter from the default output context, but leaves Month.
The formula now has a “break” on month. In other words, on every row where Month is 1,
this expression now means “the total revenue of all month 1s”. In every row where Month