HP Intelligent Management Center Standard Software Platform - Manual (Page 463)

Defining the data selection for a query
You build queries in the Query Panel by using objects in a Business Objects
universe. The objects in the universe are a graphical representation of the
information available in a database. The objects in the universe are mapped
to the table columns and rows in the database.
You can only base new documents and queries on universes for which you
have been granted the custom right, Create / Edit Query.
The Query Panel is divided into several panes:
• The pane on the left shows a tree view of the objects that your universe
contains. You cannot add new objects or edit existing objects in the Query
Panel. For information about the types of objects that might appear in
this pane, see
Quick reference to objects .
Note:
You can see all available objects in this pane by selecting "All objects."
If you want to see how objects relate to each other, select "Hierarchies."
This option provides you with a visual representation of the hierarchical
structure of objects if such a structure is present in the universe.
• The Result Objects pane is where you place the objects that you want
as part of your query.
• The Query Filters pane is where you place the objects that you want to
use to filter the data that is returned from your universe. You can define
your filter when you add an object to this pane.
To build a simple query
1. In the Query Name field, enter a name for your query.
Note:
Crystal Reports uses the query name as the name of the SQL Command
that it creates for your report. Once you have created your query in the
Query Panel, you will see this name in the Available Data Sources and
Selected Tables areas of the Database Expert.
2. Select an object in the left-hand pane and double-click it or drag it into
the Result Objects pane.
Crystal Reports 2008 SP3 User's Guide 463
18 Building Queries
Defining the data selection for a query