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 93
4. Reselect the object on the Result Objects panel and click the Add Quick Filter button
on the Report toolbar.
The List of Values dialog box appears. The values for the selected object are listed.
5. Select the value(s) you want to retrieve from the database.
For example, to filter the query for values in Q1, select the [Quarter] dimension, then
select Q1 from the list of values.
6. Click OK.
The new filter appears on the Query Filters pane.
When you run the query or refresh the document, Web Intelligence retrieves only the
values that correspond to the filter.
You can apply multiple filters to the same query. See ”Combining multiple filters on a
query” on page 95.
Using the Query Editor to create filters
Using the Query Editor allows you to choose from a range of operators to define the filter
condition and to either select values from the List of Values or to type a constant when you
define the filter value(s).
Creating a custom query filter using the Filter Editor
To create a custom query filter using the Filter Editor:
1. Make sure you are in Query View.
The Edit Query button is pressed in when you are working in Query View.
2. On the Query toolbar, click the Show/Hide Filter Pane button to display the Query
Filters pane.