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 89
The following table gives examples of when it is more efficient to type a constant or select
value(s) from list:
How many filters can I apply to a query?
You can apply one or multiple filters to a single query. For example, to retrieve data for
stores with long opening hours and only for stores in specific US states, you can combine a
pre-defined filter with a custom filter:
Stores with long opening hours
AND
State in list: California, Florida, New York
For information on how to combine multiple query filters, see ”Combining multiple filters on
a query” on page 95.
Can I filter data without including the filtered object among the report data?
If you don’t want to include a filtered object on the Data tab of reports, you can filter the
object without including the object on the Result Objects pane. This is useful if you want to
filter a query to limit the document information to specific values, but you don’t want other
users who modify the reports to see the filtered object.
Types of query filters
You can apply four types of filters to data providers when you build data providers using
the Java Report Panel:
• predefined filters – created by your administrator
• custom filters – you define on the query
• prompts – you define these dynamic filters to display a question or a list of values so
you or other users can select different filter value(s) at each document refresh
• advanced filters – subqueries and rankings
You can combine all four types of filters on a single query.
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
the List of Values.