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

Creating Custom Calculations200
Example: Default contexts in a vertical table
The following table shows the default contexts in a vertical table:
Default context in a horizontal table
A horizontal table is like a vertical table turned on its side. Headers appear at the left,
data goes left to right and footers appear at the right. The default contexts for a horizontal
table are the same as those for a vertical table.
Default contexts in a crosstab
A crosstab displays data in a matrix with measures appearing at the intersections of
dimensions. The default contexts in a crosstab are:
Body of the block The dimensions and
measures used to
generate the current
row
The same as the input
context
Footer 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
When the calculation is
in the...
The input context is The output context is
Input context
(Year, Quarter)
Values aggregated
to single output
Input and output
context (Year,
Quarter)
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.