Course Title:
BusinessObjects Designer XI Universe Design

Duration: 3 days

Course Overview
BusinessObjects XI R1 and BusinessObjects XI R2
This course is designed to teach learners using both versions of the XI release to how to design
BusinessObjects universes using Designer.
New features covered in this courses that are not applicable to BusinessObjects XI Release 1
learners 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

Target Audience


Who should attend?
The target audience for this course is universe designers.

Prerequisites


A solid understanding of relational databases and client-server concepts. Must be SQL-literate and
familiar with report creation and analysis from a user perspective using either BusinessObjects,
DesktopIntelligence or WebIntelligence.

Course Content


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

My group have used Pentland Training twice in the past two years for in-house Oracle courses. Pentland Training was recommended to us by another group with whom we interact within GSK.

The two courses met all our objectives relating to price, content covered, and tailoring to our needs. The last objective of having customised course content was especially important to us as other training companies tended to offer “one size suits all” training where much of the content was irrelevant to our needs.

Pentland will be our first choice for future training needs.

Data Management Manager
GlaxoSmithKline


Enter your email address to register for our newsletter:


IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

follow us on Twitter