Code: 
BOU310
Duration: 
3 Day(s)
Price: 
£1500

Overview

This three-day training course is designed to give learners the comprehensive skills needed to design, build and maintain BusinessObjects XI R3 Universes.

Prerequistites

  • A solid understanding of relational databases and client-server concepts is required.
  • Delegates must be SQL-literate.
  • Participants should be familiar with report creation using either BusinessObjects, Desktop Intelligence or Web Intelligence.

Skills Gained

Participants will gain the knowledge to create and deploy BusinessObjects Universes with in the XIr3 Environment

Course Specifics

Course Outline

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

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 and maintaining Universes


Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Course Location Days Cost Date
Onsite
3 1350 £1350 2018-07-16
Birmingham
3 1500 £1500 2017-11-13
Leeds
3 1500 £1500 2017-11-03
Liverpool
3 1500 £1500 2017-10-25
Exeter
3 1500 £1500 2017-10-04
Belfast
3 1500 £1500 2017-09-13
Oxford
3 1500 £1500 2017-08-22
Bristol
3 1500 £1500 2017-08-07