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 229

Ranking Data

Overview

This chapter describes ranking data in Web Intelligence. Ranking allows you to isolate the

top and bottom records in a set based on a variety of criteria.

For example, if you have a

block showing countries and associated revenues, ranking allows you to rank the data in the

block to show the top 3 countries only, based on the revenue they generate.

Ranking allows you to answer business questions such as:

• Which 3 regions generate the most revenue?

• Which are the bottom 10% of stores in terms of revenue generation?

• What is the group of the best-performing stores that generates a combined revenue of

up tot $10,000,000?

• What is the group of the worst-performing stores that generates a combined revenue of

up to 30% of the total revenue?

Web Intelligence allows you to rank data in many ways to answer these kinds of business

questions. You can:

• rank the top and/or bottom n records by dimension (for example Country) based on

the sum of a related measure (for example Revenue)

• rank the top and/or bottom n% of the total number of records by dimension based on

the value of a related measure as a percentage of the total value of the measure

• rank the top and/or bottom n records by dimension based on the cumulative sum of a

related measure

• rank the top and/or bottom n records by dimension based on the value of a related

measure as a cumulative percentage of the total value of the measure

Ranking workflows

There are two ways of ranking data in Web Intelligence. You can:

• create a ranking by using the Web Intelligence interface

• use the

Rank() function to return a ranking value

This chapter explains how to create a ranking using the Web Intelligence interface. For

more information on the

Rank() function, see ”Web Intelligence functions” on page 337 on

page 229 or the Web Intelligence online help.