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 providers34
information to the database. Web Intelligence can generate SQL data providers of
unlimited length. When the data is returned to the Web Intelligence report panel, it is
presented in a table form, with columns that have the same names as the objects that you
used in the query. The data is arranged in rows.
Data providers and queries are based on universes
You build data providers and queries in the Java panel using objects in a universe. A
universe is a representation of the information available in a database. This information is
presented in everyday terms that describe your business situation. The universe appears on
the Data tab to the left of the Result Objects and Query Filters panes.
What does a universe contain?
Universes are made up of objects and classes. These are described below:
Query Filters pane
Result Objects pane
Data tab
Universe
component
Description
Object Named component that maps to data or a derivation of
data in the database. You use objects in a query to retrieve
data for your reports. For example, some of the objects in a
sales universe would be Products, Region, and Sales
Revenue.