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 111
Creating a database ranking
You create a database ranking in the Query Panel.
Note: You can mix database rankings and other types of query filter in the Query Filters
pane.
To create a database ranking
1. Add the objects that you want to appear in your query to the Result Objects pane of the
Query Panel.
2. Select the dimension that you want to rank by.
3. Click Add a database ranking on the toolbar.
The ranking outline appears in the Query Filter pane. The dimension you selected
appears as the ranking dimension and the first measure in the query appears as the
ranking measure in the Based on box.
Number of records The number of records to return in the ranking.
For example, the top 10.
Ranking
dimension
The dimension used in the ranking. For example,
if the dimension is Region and the ranking is Top
10, the ranking returns the top 10 regions.
Based on The measure by which the ranking dimension is
ranked. For example, if the measure is Revenue
and the dimension is Region, Web Intelligence
ranks regions by the amount of revenue they
generate
For Each (optional) Dimension that specifies additional calculation
context for the ranking. For example, if the
ranking dimension is Region, the measure is
Revenue and the For Each dimension is Country,
Web Intelligence ranks regions by revenue
within each country.
WHERE condition
(optional)
Additional restriction on the values returned in
the ranking that appears below the other
parameters. For example, a ranking of regions
with a condition that restricts Country to “USA”
ranks only those regions in the USA.
Parameter Description