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 235
This ranking gives the following result:
To calculate this ranking, Web Intelligence:
• sorts the records in ascending order
• works through the records until it reaches the record that causes the cumulative total of
the measure, expressed as a percentage of the overall total of the measure, to exceed
30%
• displays those records that do not cause the cumulative percentage to pass 30%
Ranking and sorts
Web Intelligence sorts data as part of applying a ranking. For example, if you rank the top
3 stores by revenue, Web Intelligence sorts the stores in descending order by revenue
generated.
The sorts that Web Intelligence applies in rankings take precendence over sorts that you
have previously applied to your data. For example, if you have previously sorted the list of
stores in alphabetical order, Web Intelligence overrides this sort when applying the
ranking.
Tied rankings
Web Intelligence assigns equal ranking values to tied rankings and pushes back the
ranking values of the rows after the tie. This means that a bottom n ranking can return
more than n records.
Example: Top and bottom tied rankings
Based on Revenue
Calculation mode Cumulative percentage
Region Revenue
South East 1,000,000
South West 2,000,000
Parameter Value