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 57
Note: SQL is the standard query language of relational databases, although each
database has its own dialect.
If your database does not support the type of combination in your query, Web Intelligence
performs the query at the report level by generating multiple SQL queries whose data it
resolves after retrieval from the database. For more information on the SQL generated by
Web Intelligence, see ”Viewing and editing the SQL behind the query definition” on
page 43.
Building a combined query
You build a combined query in the Query Panel.
To build a combined query
1. Create an initial query in the Query Panel.
2. Click Combined Query on the toolbar.
Web Intelligence adds a copy of the initial query to the data provider. The second
query has the following characteristics:
• It contains the same report objects as the original query.
• It does not contain the filters defined on the original query.
• It is combined with the original query in a UNION relationship.