BOU310 (DM310v3.0) SAP BusinessObjects Universe Designer XI 3.0: Universe Design

3 days instructor-led course

BusinessObjects Edge Series XI 3.0

This course also applies to you if you are a system administrator for BusinessObjects Edge Series. Any product differences between BusinessObjects Edge and BusinessObjects Enterprise are outlined within the course so you understand which areas do not apply to you deployment. A document with more information about these differences and how this course applies to you is included on the resource CD.
        
This three-day instructor-led course is designed to give you the comprehensive skills needed to design, build and maintain BusinessObjects 6.5 and BusinessObjects XIR1/XIR2 universes.
You should attend this course to understand universe design concepts and terminology, as well as the role of universes in relation to BusinessObjects reporting tools. The course provides an overview of the process for planning, designing and creating a universe and then walks you through the process of designing a universe that responds to identified requirements.
The business benefit of this course is that you will learn best-practice methodology for creating universes that respond to your reporting requirements. Through well-designed universes, report designers and business users will be able to create reports without having to know anything about the underlying data source or structure.

Course Audience

This course is designed to teach you how to design BusinessObjects universes using Universe Designer, using BusinessObjects 6.5, BusinessObjects XI R1/R2, or BusinessObjects XI 3.0.
New features covered in the XI 3.0 course that are not applicable to BusinessObjects 6.5 or XI R1/R2 learners include:

  • Creating a cascading list of values associated with a hierarchy of objects in a universe
  • Creating delegated measures
  • Creating nested derived tables

The target audience for this course is universe designers.

Prerequisites

To be successful, learners who attend this course should have attended the following offerings:

  • BusinessObjects Web Intelligence XI 3.0: Report Design

To be successful, learners who attend this course should have the following experience:

  • SQL and relational database management systems concepts and structures
  • Familiarity with the type of data and the logical structure of the databases in their organization
  • Familiarity with BusinessObjects Web Intelligence report building

Course Topics

Lesson 1: Understanding BusinessObjects Universes

  • BusinessObjects universe concepts
  • The Universe Development Cycle

Lesson 2: Creating the Course Universe

  • The course database and universe
  • Creating the universe

Lesson 3: Building the Universe Structure

  • Populating the universe structure
  • Defining joins in a universe

Lesson 4: Creating Dimension Objects

  • Classes and objects
  • Creating classes and objects

Lesson 5: Creating Measure Objects

  • Measure object concepts
  • Creating measure objects
  • Delegated Measures

Lesson 6: Using Lists of Values

  • Creating a list of values
  • Working with LOVs in Universe Designer
  • Creating a cascading LOV

Lesson 7: Resolving Loops in a Universe

  • Understanding loops
  • Resolving loops using aliases
  • Resolving loops using shortcut joins
  • Resolving loops using contexts

Lesson 8: Resolving SQL Traps

  • Understanding SQL traps and universes
  • Detecting and resolving chasm traps
  • Detecting and resolving fan traps

Lesson 9: Applying Restrictions on Objects

  • Restricting the data returned y objects

Lesson 10: Using @functions with Objects

  • Using @functions

Lesson 11: Using Hierarchies

  • Understanding hierarchies and universes
  • Working with hierarchies

Lesson 12: Derived Tales and Indexes

  • Using derived tables
  • Applying index awareness

Lesson 13: End-of-Course Challenge

  • End-of-course challenge