BusinessObjects Universe Designer – Beginner

Training for SAP BusinessObjects Universe Designer XI 3.1

Book this course

 

Introduction

This three-day beginner training course is intended to equip delegates with the comprehensive knowledge and skills required to design, build and maintain BusinessObjects XI 3.0/3.1 Universes.

Whilst you do not need any prior experience with the Universes software, you must be confident in report creation using either BusinessObjects, Desktop Intelligence or Web Intelligence, be SQL-literate and have good understanding of client-server concepts and relational databases.

By the end of the 3 days attendees will understand how to translate end user reporting requirements into an optimal universe design to ensure that your organisation’s Business Intelligence needs are met.

Click here to book your place

 

Universe Designer Training – Beginner Content:

Duration: 3 days

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

Universe Designer Training – Beginner Goals:

By the end of the beginner training course participants will be proficient in creating and deploying BusinessObjects Universes with in the XIr3 Environment.

Universe Design Training – Beginner Prerequisites:

To succeed on this universe design course the following competencies are strongly recommended:

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

Universe Designer Training – Beginner Audience:

This training course is particularly relevant for universe designers who are new to BusinessObjects Designer.

Related offerings:

Book this course

Follow us: