SAP BO INTRODUCTION

SAP BO INTRODUCTION

    Universe
  
     A universe is a file that contains:

   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. Objects and classes are both visible to Interactive Analysis users.

• a schema of the tables and joins used in the database. Objects are built from the database structures that you include in your schema. The schema is only available to Designer users. It is not visible to Interactive Analysis users.

• 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.

    Role of a Universe

The role of a universe is to provide an easy to use and understand interface, for non technical Interactive Analysis users. Also to run queries against a database to create reports and perform data analysis.

What does a universe contain

Universe is basically divided into two areas:

1.Universe Pane 

2.Structure  Pane

Universe Pane:

Classes 

Objects

Classes: A class is a logical grouping of objects within a universe. It represents a category of objects. The class name should indicate the category of the objects that it contains. A class can be divided hierarchically into subclasses.

Objects: An object is a named component that maps to data or a derivation of data in the database. The name of an object should be drawn from the business vocabulary of the targeted user group. For example, objects used in a universe used by a product manager could be Product, Life Cycle, or Release Date. A universe used by a financial analyst might contain objects such as Profit Margin or Return on Investment.

Types of objects 

In Designer, the objects are classified as dimension, detail, and measure.  

Structure Pane: 

As a universe designer you create this schema based on the tables and join that are required to return the data, needed by users for their analysis and report creation.
The schema is a part of the universe file, but is only visible and accessible in Designer. You can create a schema in the "Structure pane" of the "Universe window".