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 183
4. Select the dimension, detail or measure that you want to include in the filter, then click
>> or drag the filter to the Filter pane to add it to the filter.
5. To remove a dimension, detail or measure from the filter, select it in the Filter pane,
then click << or drag the dimension, detail or measure back to the Available Objects
pane.
6. Select the dimension, detail or measure in the Filter pane.
7. Select the operator that you want to use with the dimension, detail or measure from the
drop down list of operators.
8. Type the value or values that you want to associate with the operator or click Values to
display the Quick Filter dialog box that you use to select the values by which to filter.
For more details on quick filters, see ”To define a quick report filter” on page 180.
The number of values that you associate with the operator depends on the operator.
For more details, see ”Values used with filter operators” on page 177.
9. Click Update Filter.
The filter on the dimension, detail or measure is updated in the Filter pane. For
example, if you filtered the Country dimension to return only those rows where the
country is ‘US’, the text reads ‘Country Equal To US’.
10.Repeat from
step 4 for all dimensions, details and measures that you want to include in
the filter.
When you add multiple dimensions, details or measures, Web Intelligence links them
by default with the AND operator. To toggle between AND and OR, double click the
operator.
For more information on the AND and OR operators, see ”The AND and OR
operators” on page 181
Nesting filters
When you nest filters you set up an order of precedence between them. Web Intelligence
executes the first filter in the order or precedence, then applies subsequent filters. (Country
= ‘US’ AND Resort = ‘Bahamas Beach’) OR (Revenue > 500000) is an example of
combined and nested filters. Web Intelligence filters according to the nested filter Country
= US AND Resort = Bahamas Beach (which is also an example of a combined filter) then
applies this filter along with the combined filter Revenue > 500000.
To nest report filters
1. Create the initial filter.
2. Select the dimension in the initial filter. (Select any of the dimensions or operators in the
initial filter if it is a combined filter.)
3. Click Add Nested Filter.
Web Intelligence adds a nested OR operator to the initial filter.
4. Select the OR operator.
5. Double click the OR operator to change it to AND if you want your nested filter to be
linked to the initial filter by an AND operator.