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

Ranking Data230
Note: When you create a ranking using the interface, Web Intelligence uses the Rank()
function behind the scenes to assign ranking values.
Creating a ranking using the Web Intelligence interface
When you rank the data in a block by using the Web Intelligence interface, you tell Web
Intelligence to sort and filter the data in the block according to the rank. For example, if
you rank the top 3 countries in a block by revenue, Web Intelligence sorts the countries in
descending order by revenue, then filters the block to remove all countries other than the 3
with the highest revenue.
To create a rank using the Web Intelligence interface
1. Select the block that you want to rank.
2. Click
Rank.
The Create Rank dialog box appears.
3. Click Top and select the number of records if you want to rank the highest records in
the block.
4. Click Bottom and select the number of records if you want to rank the lowest records
in the block.
5. Select the measure on which the ranking is based in the Based on list.
6. Click For Each and select the dimension on which the ranking is based if you want to
rank on a particular dimension rather than all dimensions in the block.
7. Select the rank calculation mode in the Calculation mode list.
8. Click OK.