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 filters98

Using Or

Using Or to combine all three filters returns data that matches any one of the filters:

In this case, Web Intelligence returns values for Texas for all quarters and data for all

states in Q4, and data for all states where sales revenue was greater than $2M.

Using And and Or

You can retrieve data that answers either the criteria specified in one filter or the criteria

specified in the other filter(s). You can combine the first filter with either the second or third

filter by using And and Or as follows:

In this case, Web Intelligence retrieves data that corresponds to:

• the first filter – [State] Equal to Texas

and

• that also corresponds to either

• the second filter – [Quarter] Equal to Q4

• the third filter – [Sales Revenue] Greater than $2M

Using Or and And

You can reverse the operators and combine the same three filters as follows:

In this case, Web Intelligence retrieves data that corresponds to:

• the first filter – [State] Equal to Texas