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 239
17
Filtering the values displayed in reports
Overview
This chapter tells you how you can filter the data displayed in Web Intelligence reports to
focus on the information that interests you for a specific business purpose. You do this by
applying report filters.
This chapter explains how:
•
report filters work
• you create report filters
• you combine multiple filters on a single report
• you view the filters applied to a report
• you edit and remove report filters
How report filters work
You can filter reports to limit the results that are displayed to specific information that
interests you. For example, you can limit the displayed results to information for a specific
customer or a sales period. The data you filter out remains within the Web Intelligence
document; it is simply not displayed in the report tables or charts. This means you can
change or remove report filters in order to view the hidden values, without modifying the
query definition behind the document. You can apply different filters to different parts of a
report. For example, you can limit the results in the entire report to a specific product line
and then limit results in a table or chart further to focus on results for a specific region or
customer profile.
Example: Using report filters to focus on different information on the tables and charts
on a single report
You want to display results for all product lines in the state of California, where you have
recently started doing business. You want to view results for the accessories product line in
all states, to decide in which state you need to carry out a promotional campaign to
increase sales. In the same report you filter the table for product line, so that only results for