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 99
or that corresponds to
• both the second filter – [Quarter] Equal to Q4 and the third filter – [Sales Revenue]
Greater than $2M
Applying query filters to business questions
This section provides examples of how you can apply query filters to Web Intelligence
documents to answer typical business questions.
Retrieving a range of values
Using filters to retrieve a range of values is useful if you want to define a date range to
analyze invoices or orders for a particular calendar period, or if you want to define an
alphabetical range; such as for customer names or product lines.
Example: Analyzing the payment status of invoices sent to customers in December
2002
In this example you want to analyze the payment status of all invoices sent to customers
during the month of December, 2002. To do this you need to retrieve data for invoices
dated between December 1, 2002 and December 31, 2002.
To do this:
1. Click the Edit Query button on the Web Intelligence toolbar.
Query View appears.
2. Drag and drop the [Invoice Date] object into the Query Filters pane.
The Filter Editor dialog box appears.
3. Select the operator Between.
NOTE:
1. If you know how dates are typed into the database, select Constant. If you are unsure
how dates should be typed or you want to select from new values entered into the
database that you haven’t yet seen, select Value(s) from list.
To retrieve data that... for example... double-click...
include a range of
values,
retrieve data for 12/01/02
through 12/31/2002,
Between
omit a range of values, Exclude data for 12/01/02
through 12/31/2002,
Not between