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

Filtering data retrieval using query filters86
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, measures, and details, see ”What types of objects can you use in
a query?” on page 35.
Note: Your administrator can prevent objects from being filtered. If you create filters on
these objects, when you try to run the query a warning appears listing the filters that you
cannot use. You need to remove these filters from the query in order to run the query.
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 query filters and provides an
example of each operator in the context of a business question:
To obtain data... for example... select... to create the filter...
equal to a value
you specify,
retrieve data for
the US only,
Equal to [Country] Equal to
US.
different from a
value you
specify,
retrieve data for
all quarters
except Q4,
Not Equal
to
[Quarter] Not Equal
to Q4
greater than a
value you
specify,
retrieve data for
customers aged
over 60,
Greater
than
[Customer Age]
Greater than 60
greater than or
equal to a value
you specify,
retrieve data for
revenue starting
from $1.5M
upward,
Greater
than or
equal to
[Revenue] Greater
than or equal to
1000500
lower than a
value you
specify,
retrieve data for
exam grades
below 40,
Less than [Exam Grade] Less
than 40
lower than or
equal to a value
you specify,
customers whose
age is 30 or less,
Less than or
equal to
[Age] Less than or
equal to 30
between two
values you
specify that
includes those
two values,
weeks starting at
week 25 and
finishing at 36
(including week
25 and week 36),
Between [Weeks] Between
25 and 36