|
Course Description
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 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 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
Duration: 3 days
Curriculum: Course topics include:
Understanding BusinessObjects 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
Using Hierarchies
Deriving Tables & Indexes
- Use derived tables
- Apply index awareness
End-of-Course Challenge
- Design & create the Prestige Motors universe
|
|
