HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Working with combined queries60
finds the union/intersection/minus between that data set and the data returned by
Combined Query n + 2. Web Intelligence continues in this way through all the queries in
the relationship. This gives the following result for the above example:
Multiple combined queries
You can combine multiple queries in complex relationships to determine the order of
execution, as in the following example:
Web Intelligence processes query groups from right to left as they appear in the Query
Panel, and from top to bottom within each group. (Higher-precedence groups, such as the
MINUS group in the above example, appear indented to the right in the Query Panel.) In
the above query Web Intelligence first determines the result of the minus combination then
finds the intersection of this result with the result of Combined Query 3 as shown in the
following table:
Query Data
Query 1 US; UK; France; Germany
Query 2 US; France; Finland
INTERSECTION of 1 and
2
US; France
Query 3 US; Spain
Final INTERSECTION US
Query Result
Query 1 US; UK; Spain; Germany
Query 2 Germany
Query 1 MINUS Query 2 US; UK; Spain
Query 3 US; Spain; Finland