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 217
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 210 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