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 43
The level appears in the list box and the dimensions that are hierarchically below each
dimension in the Result Objects pane appear in the Scope of Analysis pane.
5. If you want to add selected dimensions to the scope of analysis or create a custom
scope of analysis, select dimensions in the Query Manager and drag them across to
the
Scope of Analysis panel.
Viewing and editing the SQL behind the query definition
When you build a query, Web Intelligence automatically generates the appropriate SQL
to retrieve the data from the database that you are accessing. You can view and edit this
SQL.
Viewing the SQL behind a query
To view the SQL behind a query:
1. Verify you are in Query view.
If the reports are displayed, click
Edit Query to go to Query view.
2. On the query panel toolbar, click
View SQL.
The SQL Viewer dialog box appears, displaying the SQL behind the query.
3. If you want to re-use the SQL in another application, click Copy to copy the SQL to the
clipboard.
Sometimes Web Intelligence generates more than one SQL statement to satisfy a query.
Web Intelligence runs each SQL query seperately, then resolves the results. This occurs in
the following situations:
• Your query contains incompatible objects. (For more information on incompatible
objects, see ”How Web Intelligence handles incompatible objects” on page 53.)
• Your document contains multiple data providers. (For more information on multuple
data providers, see ”Including multiple data providers” on page 63 on
page 63.)
[Quarter] and [Month] appear under [Year]
[SKU desc] and [Color] appear under [Category]