SAP BOBJ - Universe

Card Puncher Data Processing


A universe is a semantic layer of abstraction that exists between :

  • BusinessObjects Enterprise
  • and the data in your organization's database.

The Universe abstracts the data complexity by using business language rather than data language to access, manipulate, and organize data.

Bobj Universe Diagram Role

Uinverses are a core component of BusinessObjects Enterprise. All universe objects and connections are stored and secured in the central repository by the Connection Server. Universe designers need to login to BusinessObjects Enterprise to access the system and create universes.

The semantic layer allows SAP BO - Web Intelligence to deliver documents, by utilizing multiple synchronized data providers, including online analytical processing (OLAP) and common warehousing metamodel (CWM) data sources.

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.
  • A schema of the tables and joins used in the database.

This business language is stored as objects in a universe file. The universes are stored in the Central Management Server ( CMS ) repository

A univers is composed of :

Who use Universe ?

Web Intelligence and Crystal Reports use universes to simplify the user creation process required for simple to complex end-user query and analysis.

You make a universe available to Web Intelligence users and other designers by exporting a universe to the repository.

When you export a universe the universe is:

Universe Management

How to create a universe ?

You can create universes from metadata sources with both Universe Builder and Universe Designer.

Given that you can use either Designer or Universe Builder to create a universe from metadata source, why use Universe Builder and when do you use it?

Universe Builder is an independent product. You can update the metadata plugins used to generate universes when newer versions are available from Business Objects.

Designer can not be updated with new or updated metadata exchange plugins. The metadata source support is fixed at the level of the installed version.

You use either Designer or Universe Builder based on the following:

  • You use Universe Designer to create a universe from a metadata source supported at the time of this release.
  • You use Universe Builder to create a universe from a metadata source plugin that has been updated, or to use a plugin for a newly supported metadata source.

Delete, Organize, Security

In the central management console, in the universe node, you can manage them :

  • delete
  • organize
  • security

Universe access and row-level security can also be managed at the group or individual user level from within the design environment.

Discover More
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

The PRM file is a text file that lists parameters used to configure universes creation and SQL query generation in Web Intelligence. There is a PRM file for each supported RDBMS. PRM files are located...
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 Designer User Interface
Business Object - Universe Designer

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...
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....
Card Puncher Data Processing
Report and Processing servers

The processing tier includes the following servers: Web Intelligence Report Server Desktop Intelligence Report Server (RAS) Crystal Reports Processing Server Web Intelligence Processing Server...
Bobj Architecture Overview
SAP BOBJ - Business Object XI Architecture

BusinessObjects XI is a multitier, server-based product that comprises a number of logical servers. These servers run as Windows services, and they can all be installed on one machine or distributed across...

Share this page:
Follow us:
Task Runner