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

Creating Custom Calculations214
Without the Break keyword this column would duplicate the figures in the Sales revenue
column, because it would use the default output context ([Year];[Quarter]).
For more information on default contexts, see ”Default calculation contexts” on page 199.
The Block keyword
The following table describes the dimensions referenced by the Block keyword depending
on where it is placed in a report: The Block keyword often encompasses the same data as
the Section keyword. One difference is that Block accounts for filters on a block whereas
Section ignores them.
Example: The Block keyword
You have a report showing Year, Quarter and Sales revenue. The report has a section
based on Year. The block is filtered to exclude the third and fourth quarters. The Yearly
Average column has the formula:
Average([Sales revenue] In Section)
When placed in... References this data...
A block Data in the whole block,
ignoring breaks, respecting
filters
A block break (header or footer) Data in the whole block,
ignoring breaks, respecting
filters
A section (header, footer, or outside
a block)
Not applicable
Outside any blocks or sections Not applicable