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 reports242
What objects can I filter?
You can define filters on any of the dimension, measure, details, and variables listed on
the Data tab of the document.
For example, you can filter the [Year] dimension to return values for a specific year, filter
the [Revenue] measure to return values for a range of revenue figures, or filter the [Postal
Code] detail to return values for a specific postal area. For an illustrated description and
examples of dimensions and details, see ”What types of objects can you use in a query?”
on page 35.
Which operator should I choose?
It is important to understand the effect of each operator available to you when you define
a filter. The table below lists the operators available for report filters and provides an
example of each operator in the context of a business question:
dimension
measure
detail
variablevariable
To obtain data
that...
for example to... select this
operator...
to create this
filter...
is equal to a
value you
specify,
retrieve data for
the US only,
Equal to [Country] Equal
to US.
is different from
a value you
specify,
retrieve data for
all quarters
except Q4,
Different from [Quarter]
Different from
Q4
is greater than a
value you
specify,
retrieve data for
customers aged
over 60,
Greater than [Customer Age]
Greater than 60
is greater than
or equal to a
value you
specify,
retrieve data for
stores where the
sales floor size is
4,000 Sq. ft. or
more,
Greater than or
equal to
[Sales Floor Size
Group] Greater
than or equal to
4000