This course is designed to give you the comprehensive skills needed to design, build, and maintain BusinessObjectsTM XI Releases 1 and 2 universes.
This course will help you 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 walks you through the process of designing a universe that responds to your identified user requirements.
In this course, you will learn best-practice methodology for creating universes that respond to your 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. That means more time is available to you for higher priority projects.
BusinessObjects XI Releases 1 and 2
This course will teach designers using either release 1 or 2 of BusinessObjects to create universes using Designer. New features covered in this course specific to BusinessObjects XI Release 2 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
Course Audience
The target audience for this course is universe designers.
Course 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 (LOV)
- 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
Prerequisite Education
If designers want to increase their skill level and knowledge of BusinessObjects Web IntelligenceTM reporting skills and concepts, this course is recommended:
Prerequisite Knowledge/Experience
To be successful, designers 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.
Additional Education
If you want to maximize your skill level and knowledge of Designer, and apply it to designing question domains for use with the Intelligent Question application, this course is recommended:
- BusinessObjects Intelligent Question XI R2: Question Designer Basics
Delivery & Duration
This instructor-led offering is a three-day course.
Applicable Certification
This course is not applicable to any Business Objects Certified Professional programs.