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

Building Reports Using the Web Intelligence Java Report Panel 329
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 314.
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