HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Building basic data providers44
• You have used a combined query and the database does not support the combination
operator you used. (For more information on combined queries, see ”Working with
combined queries” on page 55 on
page 55.)
In each case you see a hierarchical view of the SQL queries on the left of the dialog box.
The root item of the hierarchy is labelled according to the reason why the SQL was
generated in multiple queries. For example, if the SQL was generated from a combined
query using MINUS, the root item is Minus; if the SQL was generated from a query
containing incompatible objects, the root item is Synchronization.
Viewing the SQL behind a query with mutliple SQL statements
To view the SQL:
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. In the left pane, click the root item to expand the hierarchy of SQL queries. (The queries
are name Select 1, Select 2... in the hierarchy.)
4. Click the the query you want to view to display the SQL in the right pane.
If you want to re-use the SQL in another application, click Copy to copy the SQL to the
clipboard.
Editing 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. Click Use custom SQL.
The SQL becomes editable.
4. Edit the SQL then click Validate to ensure that it is correct.
5. Click Save to save the new SQL.
Defining query properties
You can set properties for the query that can optimize the time taken for the query to run,
or the amount of data returned, set security options, specify the order of prompts in the
report, and control potential ambiguous query results. The query properties options are
grouped together in sections on the
Properties tab in Query View.