Course Description
This two-day instructor-led advanced course is designed to give you the comprehensive skills and in-depth knowledge needed to design universes in BusinessObjects Designer.
The business benefit of this course is that you will learn best-practice methodology for creating universes that respond to your reporting requirements. Through well-designed universes, report designers and business users will be able to create reports without having to know anything about the underlying data source or structure.
BusinessObjects XI R1 and BusinessObjects XI R2
This training offering is based on BusinessObjects XI R2 Service Pack 2 (SP2).
Course Audience
The target audience for this course is anyone responsible for creating and designing universes using a BusinessObjects Enterprise XI R2 SP2 environment. You will be most successful if you have experience working with BusinessObjects Designer.
Course Topics
Lesson #1 – Universe Development Process
Understanding the metadata
Universe Development Cycle
Best practices for universe design
Lesson #2 – Universe Parameters
Data access files and connection parameters
BusinessObjects dynamic SQL parameters
Connection and user credential parameters
Lesson #3 – Advanced Objects Scenarios
Combining database functions in objects
Constructing relative date-time objects
Working with Transact_SQL functions
Lesson #4 – Complex Predefined
Conditions, LOVs and Joins
Complex predefined conditions
Advanced LOVs
Advanced Join syntaxes
Lesson #5 – SQL Traps Revisited
Chasm Traps
Fan Traps
Lesson #6 – Extended Index Awareness and
Derived Tables
Applying Index Awareness
Derived Tables
Lesson #7 – External Strategies
Creating and using external strategies
Take it Online Prerequisite Education
Interested in online courses?
Visit the Business
Objects Learning
Network:
To be successful in this advanced course, you must have working knowledge of:
SQL and relational database management systems concepts and structures
Familiarity with the metadata and logical structure of the databases in their organization cts.com/services/trainin g/elm/default.asp
BusinessObjects Universe Designer
BusinessObjects Web Intelligence™
Prerequisite Knowledge/Experience
To satisfy the above prerequisites we recommend these courses available through Passport:
BusinessObjects XI R1/R2: Universe Design
BusinessObjects Web Intelligence XI R2: Report Design
Additional Education
Not applicable for this offering.
Level, Delivery, & Duration
This advanced Instructor-led offering is a two-day course.
Applicable Certification
This course is not applicable to any Business Objects Certified Professional programs.
More Information
Americas Europe Asia-Pacific Japan
Programme scope, delivery arrangements and suitability are confirmed during enquiry.