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 245
How many filters can I include in a report?
You can include one or multiple filters in a single Web Intelligence report. Using the Java
Report Panel, you can apply filters at three levels within a report:
• the entire report
• sections and subsections
• tables, charts, and forms
Example: Using filters to compare sales revenue for Colorado and average sales
revenue across all US states
In this example, you are a sales manager for Colorado. You want to analyze year 2003
sales revenue results by product line for Colorado and compare those results with the
average sales revenue for all US states. You only want to focus on product lines that
generated more than $1M. To create a report that shows this information, you define filters
on the following parts of a report:
• Report: you filter the [Year] dimension to retrieve values for 2003
• A section for the [Product Line] dimension, which includes two tables: you filter the
section to retrieve product line data for lines where sales revenue was more that $1M
• Table 1: you filter the [State] dimension to retrieve values for Colorado
• Table 2: you don’t apply any filters, but you replace the Sales revenue measure with
a formula that calculates the average revenue for all US states:
=Average( [Sales revenue] In ([Lines];[Category];[Quarter];[State])) ForAll([State])
This gives you the following report, which lets you compare how Colorado rates compared
to the state average:
The filters are listed in the Filters sub-tab on the Properties tab. To find out how to apply
filters to each of the elements in a report, see ”Creating custom report filters” on
page 246.