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 37
What happens when you run a query?
When you run a query, you retrieve the information from the database represented by the
objects that you have added to the Results Objects pane. The request for information is
processed in the database, and the results are sent back to the Web Intelligence Java
Report Panel in the form of a document. The document contains all the information that you
asked for in the query, arranged in table columns and rows.
What happens when you interrupt run query?
You can interrupt a query before Web Intelligence has returned all the data to the
document.Interrupting a query is useful if you realize you want to change the definition of
the query after you have already clicked the Run Query or the Refresh button. For full
information on the options you can choose when you interrupt a query, see ”Interrupting
data providers” on page 51.
Returned data is stored for analysis
The data that is returned in a query is stored in the document. It is convenient to visualize
the returned data as being organized as a cube. In the document, the data is displayed as
a table. The table is a flat, two dimensional view of the of the data cube.
Each of the columns in a returned document represents an axis in the cube. You can edit
the document by swapping and manipulating the data within the cube on any axis. When
you swap or change data between different axis, the new result is again projected as a
flat table in the resulting document.
The data stored in the cube allows you to create a report that corresponds to your business
needs without having to send another query to the database.
If you want to add information to the document that is not in the cube, then you must add
the object to the query and run the query again to get the new information.
Building a simple query
Before you can create a query, you must firstly start the Web Intelligence Java panel and
select a universe. Refer to the chapter “Creating and Editing Web Intelligence Documents”
for more information on connecting to a universe.
Once you are connected to a universe, the universe objects appear in the Query
Manager. You build a query by selecting objects in the Query Manager Data page, and
adding them to the Results Objects pane. You can set various properties for the query, and
then run the query to get the data for each object.
The following is an overview of the steps that you follow to build a query. Each stage is
described in more detail in its corresponding section. A procedure for the whole process is
given in the section ”Building and running a simple query” on page 48.
You can control the amount and type of data that is returned for an object by setting filters
on the object. This is described in ”” on page 83.