About this course

Course code TPBOU310
Duration 3 Days

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

Prerequisites

  • 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.

Delegates will learn how to

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

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

3 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.