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 97
1. If necessary, change the operator to Or, by double-clicking the And operator once:
Or now displays as the operator.
Combining simple filters with combined filters
You can combine filters with other groups of combine filters to retrieve data that
corresponds to one or multiple business criteria. You combine filters with And or Or
operator. You can combine groups of filters with single filters to answer complex criteria.
The following example explains how the And and Or operators affect the data Web
Intelligence retrieves to a document.
Example: Using And or Or to combine query filters
This example illustrates how using And and Or operators in four different ways to combine
the same three query filters affects the values retrieved to a document. The three filters are
on the [State] dimension, the [Quarter] dimension, and the [Sales Revenue] measure.
Using And
Using And to combine all three filters returns data for Texas in Q4, if the Sales Revenue
total is greater than $2M:
In this case, the Sales Revenue for Texas in Q4 is over $2M, so the following values are
returned to the default report when you run the query:
When you use the And operator to combine all the query filters like this, all of the criteria
specified in all of the filters need to be matched by the data on the database for Web
Intelligence to run the query. If any one filter is unmatched Web Intelligence displays a
warning to inform you that there is no data corresponding to the query definition. If you
run the query anyway, the default report displays without any values. Only the table
headers appear.