Business Object Query Designer

BUSINESSOBJECTS makes it easy to access data from your corporate database because it has a business-intelligent, semantic layer that isolates you from the technical issues of the database. This semantic layer is called a universe. A universe maps to data in the database, using everyday terms that describe your business environment
 
What is a universe
A universe is a file that contains the following
Connection parameters for one or more database middleware
SQL structures called objects that map to actual SQL structures in the database such as columns, tables, and database functions. Objects are grouped into classes
A schema of the tables and joins used in the database. Objects are built
from the database structures that you include in your schema

Web Intelligence users connect to a universe, and run queries against a database. They can do data analysis and create reports using the objects in a universe, without seeing, or having to know anything about, the underlying data structures in the database.
Universes are created by a universe designer, using BUSINESSOBJECTS DESIGNER
Using this interface, you build a BUSINESSOBJECTS query using an editor called the Query Panel, by adding and organizing objects from a universe. Objects are elements that map to a set of data from a relational database in terms that pertain to your business situation.When you run the query, BUSINESSOBJECTS connects to the database and retrieves the data mapped to the objects you selected
A query is a type of data provider. The data provider contains the data you have chosen to retrieve from the data source. Using this data set, you can build interactive reports
 
Top