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 45
Query property options
You can set the following query properties:
Query Property Available Options and Description
Name • The name you specify for the selected query is
displayed on the corresponding query tab.
Data • Retrieve duplicate rows
In a database, the same data may be repeated
over many rows. You can choose to have these
repeated rows returned in a query, or to have
only unique rows returned.
Limits • Max rows retrieved
Maximum number of rows of data that can be
returned when a query is run. If you only need a
certain amount of data, you can set this value to
limit the number of rows of data that is returned to
your document. This prevents a query from taking
too much time or from returning unnecessary data
to the document.
NOTE: The Max rows retrieved setting
can be overridden by the limits set by your
administrator in your security profile. For
example, if you set the Max rows
retrieved setting in the HTML report panel to
400 rows, but your security profile limits you
to 200 rows, only 200 rows of data will be
retrieved when you run the query.
• Max retrieval time
Maximum time that a query can run before the
query is stopped. This can be useful when a query
is taking too long due to an excess of data, or
network problems. You can set a time limit so a
query can stop within a reasonable time.