BusinessObjects Universe Designer XI 3.0 Universe Design
Duration 3 Days
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

o   Creating a cascading list of values associated with a hierarchy of objects in a universe

o   Creating delegated measures

o   Creating nested derived tables

·         The target audience for this course is universe designers

 

Prerequisites
  • BusinessObjects Web Intelligence XI 3.0: 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

    • Synopsis Understanding BusinessObjects Universes
    • Define BusinessObjects universe concepts
    • Use the Universe Development Cycle
    Creating the Course Universe
    • Describe the course database and universe
    • Create the 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
    • Explain measure object concepts
    • 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 and universes
    • Resolve fan traps
    • Resolve chasm traps
    Using Lists of Values
    • Create a list of values
    • Work with LOV's in Designer
    • Create a cascading LOV
    Applying Restrictions on Objects
    • Restrict the data returned by objects
    Using @ functions with Objects
    • Use @ Functions
    Using Hierarchies
    • Work with hierarchies
    Derived Tables and Indexes
    • Using derived tables
    • Apply index awareness
    End-of-Course Challenge
    • Design and create the Prestige Motors universe
    Objectives
    Topics