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 59
returns Year and Revenue, and you cannot combine a query that returns Year with a query
that returns Revenue.
You must also pay attention to the semantics of your combined queries. While it is
possible to combine a query that returns Year with a query that returns Region if both
dimensions are of the same data type, the result - a mixed list of years and regions - is
unlikely to be meaningful. Typically, if your first query contains a Year dimension, your
second query also contains a dimension that returns a list of years.
Example: Return a list of years and reservation years based on the numbers of guests
This example describes the workflow for the query described in ”Return a data set using a
combined query” on page 56. You want to build a query that returns a list of years
consisting of years where more than n guests stayed in a resort and years where more
than n guests reserved to stay in a resort. To do this:
1. Select the Island Resorts Marketing universe in the list of universes to open the Query
Panel.
2. Drag the Year object to the Result Objects pane.
3. Drag the Number of Guests object to the Query Filters pane and create a report filter
that restricts the Number of Guests to greater than n. (For more information on
building query filters, see ”Filtering data retrieval using query filters” on page 83 on
page 55.)
4. Click Combined Query.
The Combined Query pane appears in the bottom left of the Query panel with the two
queries joined by union.
5. Click on the second query and remove the Year and Number of Guests objects.
6. Drag the Reservation Year object to the Result Objects pane.
7. Drag the Future Guests object to the Query Filters pane and create a report filter that
restricts the future guests to greater than n.
8. Click Run Query.
9. The query returns the combined list of years and reservation years.
Combined query precedence
It is important to understand the order in which Web Intelligence executes query
combinations in a combined query. The order of execution is crucial in determining the
final result.
In the simplest form of combined query you combine two or more queries in a relationship
as follows:
In such a case, Web Intelligence first finds the set of data that represents the
union/intersection/minus between Combined Query n and Combined Query n + 1, then
Query 1
INTERSECTION Query 2
Query 3