HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Performing On-Report Analysis with Web Intelligence 177
15
Filtering results on reports
Overview
This chapter describes how you can limit the data displayed in your Web Intelligence
reports by using report filters after the report data has been retrieved from the data source.
This chapter explains:
•
how report filters work
• how to add and remove filters
• how to combine and nest filters
• how to view, edit, and delete filters
How report filters work
You can filter the data displayed in Web Intelligence reports to focus on the information
that interests you for a specific business purpose.
What makes up a report filter?
Web Intelligence supports two types of filters:
• query filters - these filters are defined on the query; they limit the data retrieved from the
data source and returned to the Web Intelligence document
• report filters - these filters limit the values displayed on reports, tables, charts sections
within the document, but they don’t modify the data that is retrieved from the data
source; they simply hide values at the report level
This chapter is concerned with report filters.
What types of report filter can you create?
You can create three type of report filter:
• quick filter - allows you to filter the data in one dimension or measure
• combined filter - allows you to filter the data in multiple dimensions and measures and
allows filters to be combined
• nested filters - allows you to set up an order of precedence between simple and
combined filters
Values used with filter operators
The number of values that you can use in the filter depends on the operator. For example,
you can specify many values when you use the In List operator, you can specify one value
only when you use the Equal To operator, and you do not specify a value when you use