“I appreciate the fact that we were able to easily deviate from the book when possible to cover more interesting & advanced topics. [Instructor] is very knowledgeable and honest about BO XI capabilities. Thanks.”
John F, FedEx

“[Instructor] is very knowledgeable in this subject and is able to communicate information in an easy, understandable manner. I look forward to doing the advanced class…”
– Kimberley G, Rogers Wireless

“This instructor gets a 10 out of 10. He is brilliant and has the expertise and teaching methodology that makes this type of course fun and educational. Highly recommend for future courses!!! OUTSTANDING!!!!!!!!!!!”
Attendee, Burger King Corporation

Course Description

This course is designed to provide the skills needed to create and maintain SAP Business Objects Universes. The course is focused on technical users to teach how to design universes that are efficient as well as user friendly for report creators. Students are also taught how to maintain and distribute the universes. The course provides a comprehensive coverage of universe development process and techniques, allowing developers to understand the issues that they may encounter in a real world scenario and how to tackle these problems.


This course is targeted for technical users that need to create and distribute SAP Business Objects universes for their SAP Business Objects deployments.


After completing the course, students will be able to create effective and efficient universes for their SAP Business Objects users. Students will learn techniques such as creating connections, adding tables and joins, resolving loops, creating pre-defined conditions, distributing and maintaining universes and much more. Students will also be able to create advanced universes and understand techniques such as Multisource Universes, Multilingual Universes, OLAP Universes, SQL Traps, Advanced uses of @Aggregate_Aware function, Universe Parameters and more. The course provides extensive hands on workshops in order to reinforce topics taught.

Duration & Version

5 Days – 4.x


Knowledge of report development with Web Intelligence is recommended. Also, working knowledge of databases and SQL is required.

Topics Covered

What are Universes
Data Sources
Universe Components
The Universe development process
Converting .UNV to .UNX

Starting a Project
Defining the connection
Connection types
Other Connection Parameters

Selecting the Connection
Adding Tables to the Universe
Join Types
Inserting/Modifying/Deleting Joins

Managing Folders and Sub-Folders
Managing Dimension Objects
Managing Attribute Objects

Understanding Measure Objects
Creating Measure Objects
Object Aggregation
Delegated Measures

Resolving Loops
Creating and Managing Alias
Creating and Managing Universe Contexts

Creating/Editing and Deleting
Pre-defined Conditions
Using Object Where Clause
Self-Restricting Joins
Other data restriction techniques

Understanding LOVs
Modifying LOVs
Creating Hierarchical List Of Values
Understanding Parameters
Creating and Using Parameters

Understanding Navigation Paths
Creating and Using Navigation Paths

What are @Functions

What are Derived Tables
Creating Derived Tables
Understanding Index Awareness
Using Index Awareness

Universe Deployment
Documenting Universes
Understanding Restrictions
Add/Change/Delete Restrictions
Apply Restrictions to Users and Groups

Understanding Aggregate Awareness
The @Aggregate_Aware function
Implementing Aggregate Awareness

What are SQL Traps
Understanding and Resolving Chasm Traps
Understanding and Resolving Fan Traps

Implementing Dynamic Outer Joins using the @Aggregate_Aware function
User Selectable Outer Joins

Using Joins for Relative Date Objects
Dynamic Time Period Measures From Date Dimension Tables

Multisource Universes
OLAP Universes

Managing Multiple Business Layers
Managing Multiple Data Foundation Views
Data Foundation Families
Using Shared Projects

What are Advanced Objects
Using Numeric Functions
Using String Functions
Using Datetime Functions
Using System Functions
Using CASE Statements
Relative Date Objects

Begin SQL
Join By SQL
Filter In From

Prefer Custom Training?

Schedule A Call