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 231
Ranking parameters
The following table describes the parameters that you set in a ranking and how they affect
the rank:
Parameter Description
Top/bottom When the calculation mode is Count, the ranking
returns the top/bottom n records based on the
measure specified in the Based on parameter. For
example, the top 3 countries by revenue generated,
the bottom 3 year/quarter combinations by revenue
generated.
When the calculation mode is Percentage, the
ranking returns the top/bottom n% of the total
number of records based on the measure specified
in the Based on parameter. For example, if there
are 100 records and you rank the top 10%, the
ranking returns the top 10 records.
When the calculation mode is Cumulative Sum,
the ranking returns the top/bottom records for which
the cumulative sum of the measure specified in
Based on does not exceed n.
When the calculation mode is Cumulative
Percentage, the ranking returns the top/bottom
records for which the cumulative sum of the measure
specified in Based on does not exceed n% of the
total of the measure.
n/n% When the calculation mode is Count - the number of
records to retrieve based on the measure.
When the calculation mode is Percentage - the
percentage of records to retrieve based on the
measure.
When the calculation mode is Cumulative Sum -
the cumulative sum that the measure must not
pass.
When the calculation mode is Cumulative
Percentage - the cumulative sum of the measure,
represented as a percentage of the total, that the
measure must not pass.
Based on The measure on which the ranking is based.