In formula bar, you can see formula or expression of any selected join in the “Structure” pane, or selected object in the “Universe” pane. To see the formula, select the object as shown below and you can see formula used.

sap 37 1

Following edit buttons are placed to the left of formula bar −

	Cancel last modification that has not been validated. If you make several changes to a join expression without validating the changes, clicking Cancel returns the expression to its original state. If you want to undo any individual modifications, you should use the Edit > Undo option, or click Undo.
	Validate expression. This applies any changes to the join expression. You can undo changes after validation use the Edit > Undo option, or click Undo.
	Open Edit Join dialog box for selected join.

You can modify a join using the “Formula Bar” by following below steps −

Click a join that you want to edit. The formula for the join appears in the “Formula Bar”.

sap 38 1

You can modify the expression as required and to apply change, click on validate to apply the changes.

sap 39 2

SAP Universe Designer – Universe Building

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.

sap 40 2

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.

sap 41 1

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

sap 42 1

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

sap 43 1 −

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.

sap 44 1

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.

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.

sap 46 1

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.

sap 47 1

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

sap 48 1

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.

sap 49 3

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.

sap 50 3

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

sap 51 2

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.

sap 52 2

So, this brings us to the end of blog. This Tecklearn ‘Using Formula Bar and Universe Operations in SAP Universe Designer’ blog helps you with commonly asked questions if you are looking out for a job in SAP Business Object and SAP Domain. If you wish to learn SAP IDT and UDT and build a career in SAP domain, then check out our interactive, SAP Business Objects Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-business-objects-certification-training/

SAP Business Objects Certification Training

About the Course

Business intelligence tools and features are used by multiple companies and firm for the effective results their large flow of data. The completion of this SAP Business Objects training will be helpful in landing yourself a good paying job. With this Business Objects online training, you will gain considerable proficiency in SAP BO architecture, data warehousing, use of Information design tool, create multiple reports and the implementation of Web intelligence and Efficiency in solving the issues of data sources and Crystal dashboard design.

Why Should you take SAP Business Objects Training?

The Average salary of SAP Business Objects Business Intelligence Analyst is $94,000 per annum – PayScale.com
Business Objects is an enterprise reporting tool and Scalability is one of the primary reasons large corporations choose Business Objects for their BI needs.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Introduction to Business Objects

History and Version of Business Object
How Business Objects works in SAP family
SAP BO-Business Intelligence package and tool list
Data warehousing concept from SAP perspective

SAP Business Object Architecture

SAP BO Architecture
Various tiers in architecture: Client, Processing, Intelligence

SAP Web Intelligence

Web Intelligence Overview
Variable in Web Intelligence environment

Using Universe Designer Tools (UDT)

Overview of the Universe Designer Tool
Working with shared, secured and personal connections
Understanding of the Semantic layer

SAP BO Reports

SAP BO Reports
Chart Reports, Table Reports, Sorting and aggregating of Reports
Various elements of Reports, graphs, text elements
Reports and Filters
Section Report
Break Report
Alerts Report
Scope of Analysis Panel
Conditional Reporting
Ranked Report
Drill Report

Advanced Formatting

Advanced methods of formatting in SAP BO
Identifying Chasm trap and resolving Chasm traps with various methodologies
Detection and resolving of loop

Information Design Tool (IDT) Integration

Introduction to SAP BO information design tool
Extracting data from various sources using OLAP methodologies
Creating of Universe with IDT
IDT Vs UDT
Working with IDT as an Integration tool

Getting started with Crystal Dashboard

Data visualization tool for creating interactive dashboards
Point-and-click Features
Various dashboard features and interface

Live Office

Live office
Detailed design of Crystal Dashboard

SAP BO 4.2 Features

Got a question for us? Please mention it in the comments section and we will get back to you.

478