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 providers52
1. On the Retrieving Data dialog box, click Cancel.
NOTE: The Retrieving Data dialog box appears when you click Run Query or
Refresh Data to retrieve the latest values from the database to a document.
The Interrupt Data Retrieval dialog box appears.
2. Select one of the following options:
• Restore the results from the previous data retrieval – Web Intelligence
restores the values to the document that were retrieved the last time the query was
run. The values displayed will not be the most up to date information available on
the database. You can run the query later to return the up to date values from the
database.
• Purge all data from the document – Web Intelligence displays the document
empty of values. The structure and formatting of the document is retained. You can
run the query later to return the up to date values from the database.
• Return the partial results – Web Intelligence displays the new values retrieved so
far in the appropriate parts of the document. The rest of the document will display
the values retrieved the last time the query was run.
3. Click OK.
Web Intelligence displays the results on the reports, according to the option you
selected.
About Incompatible objects in data providers
Sometimes it is not possible to use certain combinations of objects in data providers. This
situation arises when objects bear no relationship to one another. These objects are called
incompatible objects.
For example, the Island Resorts Marketing universe contains the [Reservation Year] and
[Revenue] objects, which are incompatible. This is because there is no revenue associated
with a reservation. Revenue is generated only when the customer is invoiced. The
underlying database structure reflects this; you cannot build a query that aggregates
revenue by reservation year because there is no such thing as revenue by reservation year.
In other words, the aggregation context that you specified for the [Revenue] object does
not exist.