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

Filtering the values displayed in reports244
Note: If you are building filters on the query, more operators are available. See ”Which
operator should I choose?” on page 242.
How do I specify the value(s)?
When you define report filters, you need to specify the value(s) you want to display in the
report. For example, if you want to limit the displayed data to data for one or more
countries, the value(s) you define will be the names of specific countries, such as the US
and Japan.
There are two ways you can define the values for a filter using the Java Report Panel:
• Type the value yourself – this is called a constant
• Ask Web Intelligence to prompt you with the list of values present on the database so
that you can select the values you want to display
The following table gives examples of when it is more efficient to type a constant or select
value(s) from list:
for which a
value was
entered on the
database,
customers with
children (the
children column
on the database
has a data entry),
Is not Null [Children] Is not
Null
To obtain data
that...
for example to... select this
operator...
to create this
filter...
If... for example... then...
the list of values on the
dimension or detail you
are filtering is long and
you are sure of how to
spell the value you want
to filter;
names of months or
numbers for specific
years,
type a constant.
you are not sure how to
spell the value(s) you
want to filter;
customer names or
product lines, which
can change frequently
and include unusual
spellings,
select Value(s)
from list.