BusinessObjects XI R1/R2: Universe Design - DM310R2 - 3 day(s)

Audience: The target audience for this course is universe designers.

Prerequisites: To be successful, 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

Synopsis: This course is designed to give learners the comprehensive skills needed to design, build and maintain BusinessObjects XI and XIR2 universes.

Learners should attend this course to understand universe design concepts and terminology, as well as the role of universes in relation to BusinessObjects XI reporting tools. The course provides an overview of the process of planning, designing and creating a universe, and then walks the learners through the process of designing a universe that responds to identified user requirements.

The business benefit of this course is that learners will learn best-practice methodology for creating universes that respond to their users' reporting requirements. Through well-designed universes, report designers and business users will be able to create their own reports without having to know anything about the underlying data source or structure.

BusinessObjects XI R1 and BusinessObjects XI R2
This course is designed to teach learners using both versions of the XI release how to design BusinessObjects universes using Designer. New features covered in this course that are not applicable to BusinessObjects XI Release 1 learners include:

• Creating a cascading list of values associated with a hierarchy of objects in a universe.
• Setting access restrictions on elements in a universe.
• Creating universes from metadata sources.

Objectives:

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 the 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

BusinessObjects classes provided through InfoSol.

For more information or to schedule this class, contact: corecollege@vipconsulting.com