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

Ranking Data232
Ranking examples
In the following examples, you have a dimension, Region, and a measure, Revenue, which
give the following values:
Example: Rank the top 3 regions by revenue generated
To perform this ranking you set the following parameters:
For Each The dimension on which the ranking is based (for
example, country). If you do not specify this
parameter the ranking is based on all the
dimensions in the block. For example, if you have a
block with Year and Quarter and you do not specify
a dimension, Web Intelligence uses the values of the
Based on measure generated by the year/quarter
combination.
Calculation mode The type of calculation used to create the ranking.
See the description of the Top/Bottom and n/n%
parameters at the top of this this table for more
information.
Parameter Description
Region Revenue % of Total Revenue
South East 1,000,000 7%
South West 2,000,000 13%
North East 3,000,000 20%
North West 4,000,000 24
Central 5,000,000 33%
Parameter Value
Top/Bottom Top
n/n% 3
For Each Region (or unspecified because region
is the only dimension in the block and
therefore the default ranking dimension)