HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Filtering data retrieval using query filters100
2. Enter the start date and end date for the month of December 2002:
3. Click OK to confirm the filter.
The new filter appears in the Query Filters pane.
When you run the query, only invoices for the month of December 2002 will be
returned to the document.
NOTE: To avoid displaying the Year column in the table, which will display the
same value “2002” in each row, remove the [Year] object from the Result Objects
pane when you define the query. The document data will still be filtered for 2002,
but the value “2002” will no longer be displayed in the report(s).
Using the In list operator to define filters
Using the In list operator for filters is useful, if you want to retrieve data for several values,
such as specific cities, product lines, or named customer accounts, that are not already
grouped together in objects on the universe.
Example: Analyzing sales revenue for the cities in your sales region
In this example, you want to analyze sales revenue for the cities that fall into your sales
region. The [City] object on the universe includes all the cities with which your company
does business. In order to analyze only those cities for which you are responsible, you
need to create a filter that selects the cities you specify.
To do this:
1. Click the Edit Query button on the Web Intelligence toolbar.
Query View displays the query definition of the open document.
2. Drag and drop the [City] object into the Query Filters pane.
If you selected Constant... if you selected Value(s) from list...
• type the date for December 1,
2002 into the From: box,
• type the date for December
31, 2002 in the To: box
• select the date for December 1,
2002 and click the From>>
button
• select the date for December 31,
2002 and click the To>> button