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 filters102
Example: Analyzing data for customers in a specific postal area by filtering the first
two letters of their post code
In this example, you want to analyze data for customers living in the CA postal area. You
can do this by retrieving only the data for customers whose post code includes CA.
To do this:
1. Click the Edit Query button on the Web Intelligence toolbar.
Query View appears.
2. Drag and drop the [Post Code] object into the Query Filters pane.
The Filter Editor dialog box displays.
3. Select the operator Matches pattern.
NOTE:
NOTE: Very large databases can contain thousands of values for each table
column or row. To select multiple values quickly, you can use wildcard characters to
retrieve values that have the same string of characters in common.
1. Select the operand type, Constant.
2. In the Constant text box, type the character or numerical string you want to filter. In
this example, the character string you type will be CA.
If you only want to type a partial string, you can include wildcard characters when you
type the string definition.
3. Click OK.
To retrieve data that... for example... select...
includes an
alphabetical or
numeric character
string you specify,
a SKU code prefix,
month of birth, or
post code prefix,
Matches pattern
does not include an
alphabetical or
numeric character
string you specify,
a SKU code prefix,
month of birth, or
post code prefix,
Different from
pattern