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 101
The Filter Editor dialog box appears.
3. Select the In list operator.
NOTE: :
1. Select the Operand type, Value(s) in list.
The values related to the [City] object appear.
2. Select each city by selecting the city name(s) in the List of Values box, and then press
the >> button.
The selected cities are listed in the Values Selected list.
3. Click OK.
The new filter appears in the Query Filters pane:
When you run the query, Web Intelligence only returns the values that correspond to data
for the cities you defined in the filter.
Retrieving data that includes a specific alphanumeric string
Using filters to retrieve values with a specific string or characters is useful if you want to
retrieve data for multiple values, where all these values include the same string of numbers
or characters in their label.
This is particularly useful for retrieving data for post codes for addresses or SKU codes for
specific line categories. For example, you can retrieve post codes that include “NY,” SKU
codes that include “606,” or customer date of births that include “1971.”
If you want to... for example... select...
include data that is listed in a
list of values that you specify,
retrieve values for three
cities: London, Paris,
Tokyo,
In list
exclude data that is listed in a
list of values that you specify,
exclude values for three
cities: London, Paris,
Tokyo,
Not in
list