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 199
measures in default contexts depending on where they appear in a report. However, you
can change these default contexts. This is what is meant by defining the calculation
context.
You can see default contexts by creating a block containing Year and Sales Revenue
objects. In this case the Sales Revenue object returns the revenue by year, because
revenue is evaluated in the context of the Year dimension. If you then add the Quarter
dimension to the block, the figures in the Sales Revenue column change because the
default context is now year and quarter.
From this you can see that when you place a measure or formula in a block, the default
calculation context that Web Intelligence applies includes all the dimensions in the block.
Default calculation contexts
Depending on where you place a measure or formula, Web Intelligence selects a default
context. All the following examples use the Sum() function to illustrate default contexts.
Note: For more information on the terms input context and output context used in this
section, see ”Modifying the default calculation context using extended syntax” on
page 203
Default contexts in a vertical table
A vertical table is a standard report table with headers at the top, data going from top to
bottom and footers at the bottom. The default contexts in a down table are:
When the calculation is
in the...
The input context is The output context is
Header The dimensions and
measures used to
generate the body of
the block
All the data is
aggregated then the
calculation function
returns a single value