Back to Search Results

Training Course Summary:

To provide you with all the skills needed to efficiently create and maintain Universes for BusinessObjects and WebIntelligence, allowing you to easily access and run reports.

What skills will the delegate gain?
This course will enable delegates to:

Translate end user reporting requirements into an optimal universe design.
Create, distribute, maintain and optimize Universes for BusinessObjects and WebIntelligence deployments.
Create Universes that are effective in the ‘real world’.
Test all forms of Universe deployment.
Resolve common issues that occur while developing a Universe.
User Best Practices to maximum effect.

Pre-Requisites:

A solid understanding of relational databases and client-server concepts. Must be SQL-literate. Familiarity with report creation and analysis from a user perspective.

Who Should Attend:

Individuals who need to design, build, document, maintain and distribute BusinessObjects Universes.

Training Course Overview/Content:

Introduction
Appreciate the universe designers role, how BusinessObjects infers SQL, and the universe development process.

Building a Simple Universe
Set universe parameters.
Populate the universe structure with tables.
Create joins and test dimension, detail, and measure objects.
Organise objects in classes.

Resolving Loops, Chasm and Fan Traps
Discover how to identify and resolve loops, chasm traps and fan traps in the universe structure.

Enhancing the User Experience
Enhance the universe design to improve and simplify the user experience with BusinessObjects.
Learn how to add, modify or remove a list of values for an object.
Create and customise hierarchies to simplify drilling for end users.
How to use @ functions.

Improving Performance
Improve performance by understanding when and how to use aggregate awareness and pre-calculated aggregates from summary tables to speed up queries.

Deployment
Learn how to distribute, document and maintain universes.

Challenge
Practice your newly acquired knowledge and skills in Universe design in a ‘safe’ environment.