Student Profile: This three-day instructor led course is designed to give learners the comprehensive skills needed to design, build and maintain BusinessObjects 6.5, BusinessObjects XI R1/R2 and BusinessObjects XI 3.0 universes.

Duration: 3 Days

Prerequisites: Learners who attend this course 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.

Objectives: Learn to understand universe design concepts and terminology, as well as the roles of universes in relation to BusinessObjects reporting tools.

Topics Covered:

Understanding BusinessObjects Universes

• Define BusinessObjects universe concepts
• Use the Universe Development Cycle
  

Creating the Course Universe

• Describe the course database and universe
• Create the course universe

Building the Universe Structure

• Populate the universe structure.
• Define joins in a universe.

Creating Dimension Objects 

• Describe classes and objects
• Create classes and objects

Creating Measure Objects 

• Define measure objects concepts
• Create measure objects concepts
• Create delegated measure objects

Resolving loops in a Universe 

• Understand loops
• Resolve loops using aliases
• Resolve loops using contexts

Resolving SQL Traps 

• Understand SQL traps and universes
• Resolve fan traps
• Resolve chasm traps

Applying Restrictions on Objects 

• Restrict the data returned by objects

Using @Functions on Objects 

• Use @ Functions.

Using Hierarchies 

• Work with hierarchies

Using Lists of Values 

• Create a lists of values
• Work with LOVs in Universe Designer
• Creating a cascading LOV

Creating Derived Tables and Indexes 

• Using derived tables
• Applying index awareness

Linking Universes 

• Understand linked universes
• Create links between universes

Applying Universe Access Restrictions

• Set access restrictions on a universe.

Managing Universes 

• Document universes
• Deploy universes
• Maintain universes
• Deploy universes in multiple languages

Certification Applicability: This offering is not applicable to any certification.

Cost: $2,025