SAP BusinessObjects 4.2 Universe Design Tool (UDT)

Course Abstract:

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach BusinessObjects 4.2 Universe Design Tool concepts. Topics 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.

 

Audience:

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

 

Duration:

2 Days

 

Course Objectives:

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.2 or WebIntelligence 4.x Reporting to Test Universes and SQL Generation

 

Course Topics:

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         

 

Prerequisites:

Basic Windows Skills

  • Some Database Background
  • Some SQL Skills

· Desktop Reporting 4.1 or 

WebIntelligence 4.1 Basic Reporting (Recommended)