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 queries56
Depending on the type of combined query, Web Intelligence returns the following values:
What can you do with combined queries?
Combined queries allow you to answer questions that are otherwise difficult or impossible
to frame in a single Web Intelligence query.
Example: Return a data set using a combined query
The Island Resorts Marketing sample universe contains the dimension Year, which is
associated with guests who have already stayed in a resort, and Reservation Year, which
is associated guests who have reserved to stay in the future. Because of the structure of the
database and universe, these objects are incompatible, which means that you cannot
include them in the same block in a report. (For more information on incompatible objects,
see ”About Incompatible objects in data providers” on page 52.)
What if you want to return a single list of years that includes those years where more than
n guests stayed in a resort and those years where more than n guests reserved to stay in a
resort? You can do this using a combined query, as follows:
The union between these two queries returns the list of years that you want.
How does Web Intelligence generate combined queries?
If your database supports the type of combination in your query, combined queries work
at the database level: they alter the query that Web Intelligence submits to the database.
They do so by generating SQL (Structured Query Language) queries containing UNION,
INTERSECT and MINUS operators.
Combination type Values
UNION US; UK; Germany; France; Spain
INTERSECTION US
MINUS UK; Germany; France
Query Returns
Query 1 Years where more than n
guests stayed in a resort
UNION
Query 2 Years where more than n
guests reserved to stay in a
resort