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

Filtering data using subqueries and database ranking108
Example: Which customers bought a service that had previously been reserved in Q1
of 2003, and how much revenue have they generated?
To answer this question
1. Drag the Customer and Revenue objects to the Result Objects pane of the Query Panel.
2. Select the Service object on the Data tab.
3. Click Subquery.
The subquery outline appears in the Query Filters pane.
Operator The operator that specifies the relationship
between the Filter object and the Filter By object.
Because of database restrictions you cannot use
certain combinations of operators and Filter By
objects together. For example, if you use the
Equal To operator with a Filter By object that
returns multiple values, the database rejects the
SQL because this type of subquery requires the
Filter By object to return one value only.
In cases where the generated SQL is rejected by
the database, you see an error message showing
the error description returned by the database.
WHERE
condition
(optional)
An additional condition that constrains the list of
values of the Filter By object. You can use
ordinary report objects, predefined conditions or
existing query filters (including subqueries) in the
WHERE condition.
Relationship
operator
If there is more than one subquery, determines
the relationship between the subqueries.
AND - the conditions in all of the subqueries must
be satisfied.
OR - the conditions in any one of the subqueries
must be satisfied.
Parameter Description