BOU310 - SAP BusinessObjects XI 3.0: Universe Design

Description: This core three-day instructor-led course is designed to give you the comprehensive

skills needed to design, build, and maintain BusinessObjects 6.5, BusinessObjects XI R1 / R2,

and BusinessObjects XI 3.0 universes.

Student Profile: This course is designed primarily for universe designers.

Objectives: 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 walks you through the process of designing a universe that responds to identified requirements.

Prerequisite Education: To be successful in this course, you must have taken BusinessObjects Web Intelligence XI 3.0: Report Design

Prerequisite Knowledge / Experience: To be successful in this course, you must have working knowledge of:

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

Duration: 3 days

Curriculum: Course topics include:

Understanding Business Objects Universes

Define BusinessObjects universe concepts
Use the Universe Development Cycle

Creating the Course Universe

Describe the course database & universe
Create the universe

Building the Universe Structure

Populate the universe structure
Define joins in a universe

Creating Dimension Objects

Define classes & objects
Create classes & objects

Creating Measure Objects

Explain measure object concepts
Create measure objects
Create delegated measure objects

Resolving Loops in a Universe

Understand loops
Resolve loops using shortcut joins
Resolve loops using aliases
Resolve loops using contexts

Resolving SQL Traps

Understand SQL traps & universes
Resolve fan traps
Resolve chasm traps

Using List of Values

Create a list of values (LOV)
Work with LOVs in Designer
Create a cascading LOV

Applying Restrictions on Objects

Restrict the data returned by objects

Using @ Functions with Objects

Work with @ Functions

Using Hierarchies

Work with hierarchies

Deriving Tables & Indexes

Use derived tables
Apply index awareness

End-of-Course Challenge

Design & create the Prestige Motors universe