Integra Solutions, Inc. - Business Objects XI: Universe Design

Intelligent Business Solutions

Training

Course Description

BusinessObjects XI:
Universe Design

Description: Learn how to translate end user reporting requirements into an optimal universe design to ensure that your company's Business Intelligence needs are met. BusinessObjects Universe Design provides you with all the skills needed to efficiently create and maintain universes for Web Intelligence, allowing users to easily build, access, and run reports. A hands-on, real world approach helps you to quickly learn how to create, distribute, maintain, and optimize universes for Web Intelligence deployments.

Student Profile: This course is designed for universe designers, new to BusinessObjects Designer, who need to design, build, document, maintain, and distribute BusinessObjects universes.

Objectives: To design, optimize and maintain universes that reflect the reporting needs of end users in your organization.

Prerequisites: A solid understanding of relational databases and client-server concepts. Must be SQL-literate.

Duration: 3 days

Curriculum: Course topics include:

Understanding BusinessObjects Universes

Understand BusinessObjects universes
Use the Universe Development Cycle

Creating a Universe Connection

Set universe parameters

Building the Universe Structure

Populating the universe structure
Defining joins in a universe
Setting join options

Creating Measure Objects

Defining measure objects
Using measure objects

Creating Dimension Objects

Define objects and classes
Create classes
Create objects

Resolving Loops

Resolve loops in a universe

Applying Restrictions

Applying restrictions to objects

SQL Traps

Resolving SQL Traps

Using @ Functions

Using @ Functions

Using List of Values

Creating a LOV

Using Hierarches

Defining Hierarchies
Using Hierarchies

Aggregate Awareness

Defining aggregate awareness
Applying aggregate awareness to objects

Derived Tables

Using Derived Tables

Linking Universes

Understanding linked universes
Creating links between universe

Securing Universes

Setting access restrictions

Managing Universes

Documenting universes
Deploying universes
Maintaining universes

Creating Universes from Metadata

Creating a universe from an XML metadata file