BusinessObjects XI R1/R2: Universe Design

This course has been superseded

Try searching for alternatives

Course 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.
3 days
Contact us for pricing
 

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 Web 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

Building the Universe Structure

Populating the universe structure
Defining joins in a universe

Creating Dimension Objects

Understanding classes and objects
Creating classes and objects

Creating Measure Objects

Understanding measure objects
Creating measure objects

Using Lists of Values

Working with LOVs in Designer
Creating a cascading LOV

Resolving Loops in a Universe

Resolving loops using aliases
Resolving loops using shortcut joins
Resolving loops using contexts

Resolving SQL Traps

Resolving chasm 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

Linking Universes

Creating links between universes

Securing Universes

Setting access restrictions on a universe

Managing Universes

Documenting universes
Deploying & maintaining universes

Creating Universes from Metadata

Creating a universe from an XML metadata file