Business Object - Universe Designer

Card Puncher Data Processing


Universe Designer provides a connection wizard that allows you to connect to your database middleware. You can create multiple connections with Designer, but only one connection can be defined for each universe. This database connection is saved with the SAP BOBJ - Universe.

Designer provides a graphical interface to select and view tables in a database. The database tables are represented as table symbols in a schema diagram. You can use this interface to manipulate tables, create joins between tables, create alias tables, create contexts, and solve loops in your schema. Web Intelligence users do not see this schema.

Bobj Designer User Interface

Building the Schema

A schema is a graphical representation of database structures. In Designer you create a schema for the part of the database that your universe represents. The schema contains :

Bobj Designer Schema

Building the universe pane

Building a universe is the object creation phase of the universe development cycle. Once the schema is complete, you can build the classes and SAP BOBJ - Objects and class that users see in the Universe pane, and will use to run queries on the databases structure to generate documents and reports.

Query optimization

Query optimization can be based on the order of the tables in the FROM clause of the generated SQL.

Tables with many rows appear before tables with fewer rows. This order can be important especially for RDBMS that lack an optimizer feature.

It's no more the case with the actual databases because the goal of the optimizer is now based on the cost of each action (CBO) and not on the order of the table in the query (RBO).

By modifying the row count of tables, you can change their order in the FROM clause.

Discover More
Card Puncher Data Processing
BOBJ - Alias

Aliases are references to existing tables in a schema. An Alias is a table that is an exact duplicate of the original table (base table), with a different name. You use aliases for two main reasons:...
Card Puncher Data Processing
BOBJ - Automatic join and cardinality detection

You have two ways to create a join automatically : with the Automated Detection Tools on table insertion You can use the Designer feature Detect join to automatically detect selected joins in...
Bobj Cardinalities Detect Structure Pan
BOBJ - Cardinalities

This article talk cardinality in universe designer. The cardinality of a join does not have a role in the SQL generated when you run a query. However, Designer uses cardinalities to determine context...
Bobj Chasm Trap
BOBJ - Chasm Traps (converging many to one joins)

Chasm Traps is see as a Join Path problem or data modeling issue (convergence type ) which returns more data than expected by returning a cartesian product. A chasm trap is a type of join path...
Card Puncher Data Processing
BOBJ - Derived tables

Derived tables are similar to database views, with the advantage that the SQL for a derived table can include prompts. Derived tables appear in your Designer schema in exactly the same way as normal database...
Card Puncher Data Processing
BOBJ - Joins (Home)

The Joins in BOBJ. You have several approaches to creating joins in : Tracing joins manually in the schema (Drag and drop) Defining join properties directly ( Menu Select Insert > Join ) ....
Bobj Univers Parameters Definition
BOBJ - Universe Parameters / Data Source Connection

A connection is a named set of parameters that defines how a Business Objects application accesses data in a database file and is defined in an universes via universe designer. You can create...
Card Puncher Data Processing
BOBJ Getting Started

The most problem with Business Object is to find good tutorial to start. The key word to find tutorial on BOBJ is “Getting Started”. You can find this kind of document : on the web : Try...
Bobj Equi Join
Equi-joins in BOBJ

in Bobj. You have two equi-join types in : the simple the complex (This is a single join that links multiple columns between two tables. ) You can create a complex equi-join. This is a single...
Bobj Pk Awarness
Index Key Awareness

The Keys tab allows you to define index awareness for an object : Primary Key Foreign Key Index awareness is the ability to take advantage of the indexes on key columns to speed data retrieval....

Share this page:
Follow us:
Task Runner