SAP BusinessObjects Course

course overview

Click to View dates & book now


This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach BusinessObjects 4.x Universe Design Tool concepts.


This class is designed for technical analysts who are required to create the BusinessObjects 4.x semantic layer as an interface to the data in a data warehouse, data mart, or database.

Skills Gained

to be covered include universe creation, creating database connections, joins, classes and objects, hierarchies, loop resolution, contexts, table aliases, aggregate awareness, viewing table keys, creating predefined conditions, restrictions, index awareness, universe maintenance, and universe distribution/documentation.

The student will acquire skills to:

  • Create and Maintain Universes
  • Join Database Tables and Set or Detect Join Cardinality
  • Create Classes and Objects within Hierarchies
  • Define Dimensions, Details, and Measures
  • Using Contexts and Aliases
  • Create Predefined Conditions
  • Use Desktop Reporting 4.x or WebIntelligence 4.x Reporting to Test Universes and SQL Generation
  • Universes (Semantic Layer)
  • Classes and Objects
  • Dimensions/Details/Measures
  • Equi/Outer/Theta Joins
  • Lists of Values
  • @Functions
  • Loop Resolutions
  • Join Cardinality
  • Fan/Chasm Traps
  • Predefined Conditions
  • Aggregate Awareness
  • Contexts and Aliases
  • Hierarchies
  • Restrictions
  • Security Restrictions
  • Saving Documentation to PDF
  • Index Awareness


  • Basic Windows Skills
  • Some Database Background
  • Some SQL Skills
  • WA2411 WebIntelligence 4.x Basic Reporting (Recommended)

2 Days


Outline of SAP BusinessObjects 4.1 Universe Design Tool (UDT) Boot Camp Training BusinessObjects Overview

  • Basic Architecture
  • Administration
  • Semantic Layer
  • Definitions Review
  • Universe Development Process

Getting Started

  • Using Designer
  • Defining Database Connection
  • Setting Parameters
  • Inserting Database Tables


  • Defining Joins
  • Methods of Creating Joins
  • Creating Equi-joins
  • Creating Outer Joins
  • Creating Theta Joins
  • Detecting Joins

Classes and Objects

  • Defining Classes/Subclasses
  • Defining Object Types
  • Class and Object Organization
  • Creating Classes
  • Creating Dimensions/Details
  • Object Properties
  • List of Values
  • Deleting Objects
  • Testing Cycle


  • Creating Measures Class
  • Creating Simple Measures
  • Creating Measures Using Arithmetic Formula
  • Formatting Measures

Understanding Aliases and Contexts

  • Using Aliases
  • Using Contexts
  • Checking Universe Integrity


  • Forced Restrictions
  • Object-level Restrictions
  • Self-restricting Joins
  • Conditional Select Statements
  • Additional Inferred Joins
  • Optional Restrictions
  • Predefined Conditions
  • Understanding Index Awareness
  • Setting Primary and Foreign Key index awareness


  • @Prompt
  • @Select
  • @Where
  • @Variable
  • @Script


  • Hierarchy Types
  • Default Hierarchies
  • Automatic Time Hierarchies
  • Table Based Time Hierarchies
  • Custom Hierarchies

Aggregate Awareness

  • Summary Tables
  • Creating Aggregate Derived Tables
  • Applying Aggregate Awareness
  • @Aggregate_Aware
  • Detecting & Setting Incompatible Objects

Resolving Traps

  • Fan Traps
  • Chasm Traps
  • Procedures for Resolving Traps

Reviewing Security Restrictions

  • Group & User Security
  • Applying Security Restrictions
  • Net Security Restrictions

Documenting & Maintaining Universes

  • Documenting Universes
  • Creating Hardcopies (Printing)
  • Saving As PDF
  • Distributing Universe
  • Universe Security
  • Enterprise Distribution
  • Exporting Universes
  • Locking Universes
  • Incremental Exports
  • Version Control
  • Maintaining Universes
  • Target Database Changes
  • Impact Resolution
  • Adding New Tables
  • Object Revisions
  • Efficient Maintenance

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.