SAP Universe Designer - Universe Building


Advertisements

To build a universe, you need to organize objects and classes in Universe. Universe pane presents a hierarchical view of the classes and objects in the active universe. In UDT, you can use "Universe pane" to view, create, edit, and organize classes and objects.

Universe Pane Hierarchic

You can cut, copy, or paste objects in Universe pane. Also, it is possible to hide one or more components in the Universe Pane. These are hidden from Web Intelligence users, but remain visible in the universe design tool.

Universe Design

To hide an object in Universe pane, click on show/hide button.

Hide Button

Creating a class in Universe pane −

There are two ways to create a class in the Universe pane −

  • You can define a class manually.

  • You can drag table from the table browser into the Universe pane and this will create class automatically.

To create class manually, go to Insert → Class and enter the name of class and description −

Insert Class

To create classes using table browser, select the table in the table schema and dragging it into the Universe pane. By default, it takes table name as the class name.

Create Class

Following properties of a class are defined −

Name Can contain special characters. Must be unique in universe. A class name is case sensitive. You can rename a class at any time.
Description Comment that describes a class. This description can be viewed by users in the Query pane. Information in this field should be expressed in the business language of the user, and be relevant to their query needs. You create a line break by pressing CTRL + Return.
Edit Profile

Creating an Object in Universe Pane

You can also create an object manually inside a class manually. To create an object manually, follow the steps given below −

Right click a class in the Universe pane and select Insert Object. This will insert an object under the selected class and the Edit Properties box for the object appears.

Creating Object

Enter the name of object in name and you need to mention object names are defined as per understanding of business users. It may be different from the actual column names in database schema.

Database Schema

Select the object type − char or num or other type. To define an object, enter a select statement in the Select box → OK.

Select Box

You can also define if the object is a dimension, measure or detail. To do this, navigate to Properties tab under Object Properties. You can also use object as List of values.

List of Values

You can also edit an object definition. Double click an object → This will open edit Properties dialog box opens to the Definition page.

Make changes to object definition as per requirement and click OK.

You can define an object as given below −

  • Dimension
  • Measure
  • Detail

Following are most common aggregate functions used for measures −

  • Sum
  • Average
  • Count
  • Minimum
  • Maximum

Defining Hierarchies in Universe −

You can use default hierarchies in Universe Design tool and they are displayed as objects and classes in Universe pane. You can also create customized hierarchies using objects from different classes. New hierarchies are defined in Hierarchy editor.

To create new hierarchy, navigate to Tools → Hierarchies.

Hierarchies

This will open Hierarchy editor. To create new hierarchy, click on New button and enter the name of hierarchy. Add objects to custom hierarchies.

Hierarchy Editor

To select a series of dimensions, hold down CTRL and click each dimension. One or more dimensions are highlighted → Add button and you can see one or more dimensions appear in the right pane, under the selected hierarchy.

Selected Hierarchy

Advertisements