About this Course

Code TPBOU320
Duration 2 Days

This two day advanced course is aimed at delegates who are responsible for creating and designing universes using Universe Designer. The course is designed to give you the comprehensive skills and in-depth knowledge needed to design universes in BusinessObjects Universe Designer.


Delegates must have attended the following courses:

  • SAP BusinessObjects Universe Design XIR2, and/or Universe Design XIR3
  • SAP BusinessObjects Web Intelligence XI R2: Report Design, and/or Web Intelligence XI 3.0/3.1: Report Design, and/or Web Intelligence FastTrack


  • The metadata and logical structure of the databases in your organisation
  • Using and working with SQL and relational database management systems concepts and structures
  • The BusinessObjects Central Management Console

Delegates will learn how to

  • Comprehensively design universes in BusinessObjects Universe Designer.
  • Utilise practice methodology for creating universes that respond to your reporting requirements.
  • Allow report designers and business users to create reports without having to know anything about the underlying data source or structure


Reviewing Universe Design Concepts

  • Use your universe design and BusinessObjects Universe Designer knowledge to solve business problems
  • Describe the course universe, database data, and structure

Working with Aggregate Awareness

  • Define aggregate awareness
  • Apply aggregate awareness to objects

Designing Advanced Objects

  • Combine database functions in objects
  • Construct relative date-time objects

Creating Complex Predefined Conditions, LOVs, and Joins

  • Create complex predefined conditions
  • Work with advanced LOVs
  • Work with advanced join syntaxes

Securing Universes

  • Define connection and user credential parameters
  • Work with Central Management Server (CMS) universe security
  • Work with table mapping

Implementing Universe Life Cycle Management

  • Move content from development to production

Maintaining and Optimizing Universes

  • Optimize universes
  • Apply foreign key index awareness
  • Apply best practices for universe design

Creating Universes from Other Data Sources

  • Create a universe from an XML metadata file
  • Create stored procedure and JavaBeans universes
  • Work with OLAP universes

2 Days


This is a QA approved partner course

Delivery Method

Delivery method


Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.