Golden Consulting

BOU210 - BusinessObjects XI R1/R2: Universe Design (formerly DM310R2)

Course Description

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 XI R1/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.

BusinessObjects 6.5, XI R1, and XI R2

This course is designed to teach you how to design BusinessObjects universes using Universe Designer, using BusinessObjects 6.5 or BusinessObjects XI R1/R2.

New features covered in this course, that are not applicable to BusinessObjects 6.5 or XI R1, include:
  • Creating a cascading list of values associated with a hierarchy of objects in a universe.
  • Setting access restrictions for users and groups on elements in a universe.
  • Creating universes from metadata sources.

Course Audience

The target audience for this course is universe designers.

Course Topics

Lesson #1: Understanding BusinessObjects Universes
  • Understanding how universes allow users to query databases using their everyday business terms.
Lesson #2: Creating the Course Universe
  • The course database and universe
  • Creating a universe
Lesson #3 Building the Universe Structure
  • Populating the universe structure
  • Defining joins in a universe
Lesson #4 Creating Dimension Objects
  • Understanding classes and objects
  • Creating classes and objects
Lesson #5 Creating Measure Objects
  • Understanding measure objects
  • Creating measure objects
Lesson #6 Using Lists of Values
  • Working with LOVs in Designer
  • Creating a cascading LOV
Lesson #7 Resolving Loops in a Universe
  • Resolving loops using aliases
  • Resolving loops using shortcut joins
  • Resolving loops using contexts
Lesson #8 Resolving SQL Traps
  • Resolving chasm traps
  • Resolving fan traps
Lesson #9 Applying Restrictions on Objects
  • Restricting the data returned by objects
Lesson #10 Using Functions with Objects
  • Using @ Functions
Lesson #11 Using Hierarchies
  • Working with hierarchies
Lesson #12 Aggregate Awareness
  • Applying aggregate awareness to objects
Lesson #13 Derived Tables and Indexes
  • Using derived tables
  • Applying index awareness
Lesson #14 Linking Universes
  • Creating links between universes
Lesson #15 Securing Universes
  • Setting access restrictions on a universe
Lesson #16 Managing Universes
  • Documenting universes
  • Deploying & maintaining universes
Lesson #17 Creating Universes from Metadata
  • Creating a universe from an XML metadata file

Prerequisite Education

If you want to increase your skill level and knowledge of BusinessObjects Desktop IntelligenceTM XI reporting skills and concepts, this course is recommended:
  • BusinessObjects Desktop Intelligence XI R1/R2: Report Design
If you want to increase your skill level and knowledge of BusinessObjects Web IntelligenceTM XI reporting skills and concepts, this course is recommended:
  • BusinessObjects Web Intelligence XI R1/R2: Report Design

Prerequisite Knowledge/Experience

To be successful, you must have working knowledge of:
  • 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.

Additional Education

If you want to maximize your skill level and knowledge of Universe Designer and apply it to designing question domains for use with BusinessObjects Intelligent QuestionTM XI, this course is recommended:
  • BusinessObjects Intelligent Question XI R2: Question Designer Basics

Delivery & Duration

This instructor-led offering is a three-day course.

Applicable Certifications

This course is not applicable to any Business Objects Certified Professional programs.


Outline Location: http://www.goldencg.com/edu/outlines/dm310r2.html

Golden Consulting Group, LLC
800 Cottage Grove Road
Building 3
Bloomfield, CT 06002

Telephone:      860.242.7704
Fax:                 860.242.7866
Email:              golden@goldencg.com     



Golden Consulting Group LLC © 2008 All Rights Reserved