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 61
Note: If your database directly supports the type of combined query you wish to execute,
Web Intelligence generates SQL containing combination operators. (For more information
see ”How does Web Intelligence generate combined queries?” on page 56.) In this case
the order of precedence depends on the order of precedence defined in the database. See
your Web Intelligence administrator for more details.
Setting the order of precedence
1. Build the first query in the Query Panel.
2. Click Combined Query.
3. Repeat steps 1 and 2 until you have built all the component queries.
4. To increase the precedence of a pair of queries, drag and drop a query on to the
query with which you want to associate it in the higher-precedence pair.
Web Intelligence indents the source and target queries in the drag-and-drop operation
and combines them by default in a UNION.
5. Continue adding queries to the higher-precedence group by dragging and dropping
them on to the space between any two queries already in the group.
6. To create further higher-precedence groups within an existing higher-precedence
group, repeat steps 4 and 5.
7. Double-click the combination operators of all the groups in the query to change them as
required.
The query appears in a form similar to the following in the Query Panel. (In this
example the MINUS combination has the higher precedence.)
8. Click Run Query.
(Query 1 MINUS Query 2)
INTERSECTION
Query 3
US; Spain
Query Result