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 127
values for [State] on the left axis. The body displays values that [Sales Revenue] for each
quarter in each state.
You can include multiple dimensions in crosstabs. For example, this crosstab displays two
dimensions. The values for the [Sales Revenue] measure are values each state by quarter
for each line.
Crosstabs display values of the dimensions and measures they contain. You can include
additional headers that display the names of the dimensions and measures names. See
”Displaying object names in headers on crosstabs” on page 156.
Crosstabs are useful for presenting results that correspond to the intersection of two or
more dimensions. For example, including the [State] dimension, the [Quarter] dimension,
and the [Line] dimension as well as the [Sales revenue] measure on a crosstab allows you
to easily illustrate revenue by region per product line, per quarter.
Crosstabs with dimensions in the body
When you create crosstabs that include a dimension(s) in the body, the body cell values
are calculated according to a multi-dimensional data model. The values displayed in the