Reference Guide

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.