HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Performing On-Report Analysis with Web Intelligence 181
2. Click the Filter button on the Report toolbar or right-click and click Quick Filter on the
menu. (To display the Report toolbar, click View on the menu, then click Toolbars >
Report.)
The Quick Filter dialog box appears.
3. Select the operator you wish to use in the filter from the drop-down list. For a list of all
supported operators, see ”Operators available in report filters” on page 178.
4. Select the values that you wish to use in the filter and click >> to add them to the list of
filter values. (The number of values that you can add depends on the operator you
chose. For more details, see ”Values used with filter operators” on page 177.)
5. To remove a value from the filter, select the value in the list of filter values, then click
<<.
6. Click OK to close the dialog box and apply the report filter.
Combining and nesting filters
Typical business questions require you to retrieve information that matches more than one
criterion. For example, if you are analyzing customer services data, you will most likely
want to focus on customers for a specific time period and also for a specific region, and
probably also for a specific level of customer service contract. With Web Intelligence, you
retrieve data that answers several criteria like this by combining filters in the same query.
Combining filters
You combine filters by including more than one restriction on dimensions, details or
measures. For example, the filter Country = ‘US’ AND Resort = ‘Bahamas Beach’
combines two filters. In this case Web Intelligence displays only those rows that satisfy
both criteria.
The AND and OR operators
The two operators you use to combine and nest filters are the AND operator and the OR
operator. When you use AND to combine filters, Web Intelligence displays only the data
that matches the criteria in both the filters linked by the operator. When you use OR, Web
The list of all values associated
with the dimension
The list of values used
in the filter
Filter operators