Course Description
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 and maintaining universes
Lesson#17 – Creating Universes from
Metadata
Creating a universe from an XML metadata file
Take it Online Prerequisite Education
Interested in online courses?
Visit the Business
Objects Learning
Network:
cts.com/services/trainin g/elm/default.asp
If you want to increase your skill level and knowledge of BusinessObjects Web IntelligenceTM reporting skills and concepts, this course is recommended:
BusinessObjects Web Intelligence XI R1/R2: 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
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 QuestionTM 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
N/A
More Information
Americas Europe Asia-Pacific Japan
Programme scope, delivery arrangements and suitability are confirmed during enquiry.