Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageBusinessObjects XI R1/R2: Universe Design
Description:
This three-day instructor-led course is designed to give you the comprehensive skills needed to
design, build and maintain BusinessObjects™6.5 and BusinessObjects XI R1/XI R2 universes.
You should attend this course 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 then walks you through the
process of designing a universe that responds to identified requirements.
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.
- Cost: Price on application
- Duration: 3 days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
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 W
• eb Intelligence report building
• 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 W
• eb Intelligence report building
Understanding BusinessObjects Universes:
Understanding how universes allow users to query databases using their everyday business terms
Creating the Course Universe:
The course database and universe
Creating a universe
Creating a universe
Building the Universe Structure:
Populating the universe structure
Defining joins in a universe
Defining joins in a universe
Creating Dimension Objects:
Understanding classes and objects
Creating classes and objects
Creating classes and objects
Creating Measure Objects:
Understanding measure objects
Creating measure objects
Creating measure objects
Using Lists of Values:
Working with LOVs in Designer
Creating a cascading LOV
Creating a cascading LOV
Resolving Loops in a Universe:
Resolving loops using aliases
Resolving loops using shortcut joins
Resolving loops using contexts
Resolving loops using shortcut joins
Resolving loops using contexts
Resolving SQL Traps:
Resolving chasm traps
Resolving fan traps
Resolving fan traps
Applying Restrictions on Objects:
Restricting the data returned by objects
Using Functions with Objects:
Using @ Functions
Using Hierarchies:
Working with hierarchies
Aggregate Awareness:
Applying aggregate awareness to objects
Derived Tables and Indexes:
Using derived tables
Applying index awareness
Applying index awareness
Linking Universes:
Creating links between universes
Securing Universes:
Setting access restrictions on a universe
Managing Universes:
Documenting universes
Deploying & maintaining universes
Deploying & maintaining universes
Creating Universes from Metadata:
Creating a universe from an XML metadata file