|
Course Description
BusinessObjects XI:
Advanced Universe Design
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.
Student Profile: 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.
Objectives: This 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.
Prerequisites: 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
- BusinessObjects Universe Designer
- BusinessObjects Web Intelligence™
To satisfy the above prerequisites we recommend these courses:
- BusinessObjects XI R1/R2: Universe Design
- BusinessObjects Web Intelligence XI R2: Report Design
Duration: 2 days
Curriculum: Course topics include:
Universe Development Process
- Understanding the metadata
- Universe Development Cycle
- Best practices for universe design
Universe Parameters
- Data access files and connection parameters
- BusinessObjects dynamic SQL parameters
- Connection and user credential parameters
Advanced Objects Scenarios
- Combining database functions in objects
- Constructing relative date-time objects
- Working with Transact_SQL functions
Complex Predefined Conditions, LOVs and Joins
- Complex predefined conditions
- Advanced LOVs
- Advanced Join syntaxes
|
SQL Traps Revisited
Extended Index Awareness and Derived Tables
- Applying Index Awareness
- Derived Tables
External Strategies
- Creating and using external strategies
|
|