Intelligent Business Solutions

Training

Courses

Schedule

Enroll

Contact Us

Course Description

BusinessObjects XI:
Advanced Universe Design

Description:  This two-day instructor-led advanced course is designed to give you the comprehensive skills and in-depth knowledge needed to design universes in BusinessObjects Designer. The business benefit of this course is that you will learn best-practice methodology for creating universes that respond to your reporting requirements. Through well-designed universes, report designers and business users will be able to create reports without having to know anything about the underlying data source or structure.

Student Profile:  The target audience for this course is anyone responsible for creating and designing universes using a BusinessObjects Enterprise XI R2 SP2 environment. You will be most successful if you have experience working with BusinessObjects Designer.

Objectives:  This advanced course is designed to give you the comprehensive skills and in-depth knowledge needed to design universes in BusinessObjects Designer.

The business benefit of this course is that you will learn best-practice methodology for creating universes that respond to your reporting requirements. Through well-designed universes, report designers and business users will be able to create reports without having to know anything about the underlying data source or structure.

Prerequisites:  To be successful in this advanced course, you must have working knowledge of:

  • SQL and relational database management systems concepts and structures
  • Familiarity with the metadata and logical structure of the databases in their organization
  • BusinessObjects Universe Designer
  • BusinessObjects Web Intelligence™

To satisfy the above prerequisites we recommend these courses:

  • BusinessObjects XI R1/R2: Universe Design
  • BusinessObjects Web Intelligence XI R2: Report Design

Duration:  2 days

Curriculum:  Course topics include:

Universe Development Process

  • Understanding the metadata
  • Universe Development Cycle
  • Best practices for universe design

Universe Parameters

  • Data access files and connection parameters
  • BusinessObjects dynamic SQL parameters
  • Connection and user credential parameters

Advanced Objects Scenarios

  • Combining database functions in objects
  • Constructing relative date-time objects
  • Working with Transact_SQL functions

Complex Predefined Conditions, LOVs and Joins

  • Complex predefined conditions
  • Advanced LOVs
  • Advanced Join syntaxes

SQL Traps Revisited

  • Chasm Traps
  • Fan Traps

Extended Index Awareness and Derived Tables

  • Applying Index Awareness
  • Derived Tables

External Strategies

  • Creating and using external strategies

Copyright © 2002-2007, Integra Solutions, Inc. All rights reserved.