The Business Objects XI Developer Boot Camp course provides step-by-step instructions and techniques on how to perform a variety of BusinessObjects Report Development and Universe Design tasks for activities based on real-life work scenarios. The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment..

This course is designed to give learners the comprehensive skills needed to Plan and Scope, design, build and maintain BusinessObjects XIR2 and R3.1 Reports and Universes.  In addition, you learn how to translate end user reporting requirements into an optimal Universe design to ensure that your company’s Business Intelligence needs are met. A hands-on, real world approach helps you to quickly learn how to create, distribute, maintain, and optimise Universes and Reports for BusinessObjects deployments.

BusinessObjects XI to BusinessObjects XI R3.1 and XI R4

This course is designed to teach learners using versions XI through to XI 3.1 releases on how to design BusinessObjects Universes using Designer and Build Production Reports using Desktop Intelligence.  Also Good for XI R4 Info Design Tool developers.

Audience

The target audience for this course is Architects, Report Developers and Universe designers.

Prerequisites

Must be SQL-literate and familiar with report creation and analysis from a user perspective using either BusinessObjects, Desktop Intelligence or WebIntelligence. 

Certification applicability 

This course is applicable to Business Objects certification programmes

Course Outline

Course Overview

Business Scenario

The BusinessObjects Value Proposition

Business Objects Enterprise XI Overview

Business Objects Enterprise XI 3.1 and 4 Overview

Key Concepts

The Query and Analysis Continuum

Business Intelligence and OLAP Concepts

Universe Designer, WebIntelligence and Reporter Concepts

Data Modelling in Business Objects Environments

Building a Business Dimension Model

Analysing Data Elements from your Model

Business Dimension Model Design Issues

Identifying Source Data elements for the Model

The Report Development Process

Identify People Involved

Identify business process requirements

Identify high level entities and measures for conformance

Select requirements gathering approach

Requirements Gathering

Requirements Analysis

Create Application specification Document

Create Requirements Definition Document

Design and Build Reports

Design Test Plan

Acceptance Testing

Getting Started with Desktop Intelligence

Business Objects

The Semantic Layer

Constructing a Query

The Query Process

Presenting Data

Navigating Desktop Intelligence

Logging on to Desktop Intelligence

The BusinessObjects User Module

Viewing Existing Reports

Navigating and Opening Documents

Creating Desktop Intelligence Documents

Creating a Document

Constructing Queries

Editing Queries

Projecting Data - Aggregation

Understanding the Report Wizard

Understanding Report Manager

Designing Reports - Basic Block Formatting

Default Formatting

Formatting the Report Page

Restricting Data Returned by a Query

Conditions and Setting Conditions for Queries

Other Operators and Operands

Filters

Prompts

Wild Cards and Matches Pattern

Relational Operators in Conditions

Using logical operators for multiple conditions

Using Logical AND and OR Operators

Using Logical AND and OR Precedence

Synchronizing Reporting Data

Building Multiple Blocks from one Query

Building Multiple Queries from One Universe

Building Queries Using Multiple Universes

Building Queries from Different Data Sources

Working with Crosstabs

Creating Crosstabs

Editing Crosstabs

Changing a Table Block into Crosstab

Advanced Presentation of Reports

Using the Calculator

Other Calculations

Calculations and Crosstabs

Creating Variables

Applying Breaks In Report Blocks

Calculations and Breaks

Creating an Alerter

Creating Text Alerters

Switching Off and Remove Alerters

Creating Master Detail Reports

Page Layout

Working with Charts

 Creating a Chart in a New Document

Changing Tables and Crosstabs into Charts

Changing the Style and Size of Charts

Formatting Charts

The Universe Development Process

Strategy and Planning Phase

Analysis Phase

Design Phase

Create Technical design specification Document

Build Phase

Quality Assurance Phase

Deployment and Maintenance Phase

Navigating the Designer Module

What is the Designer Module?

Log in to Designer

Looking at Universe and Objects

Understand Universe Parameters

Structure Window and Tables

Dimension and Detail Objects

Understanding Dimension and Detail Objects

Creating Classes and Dimension Objects - Automatically

Creating Classes and Dimension Objects - Manually

Creating Classes and Dimension Objects -Detail Objects

Creating Classes and Dimension Objects - List of Values

Creating Classes and Dimension Objects -Object Formatting

Creating Classes and Dimension Objects -Testing Universe

Summary - Creating Dimension and Detail Objects

Creating Joins

 Joins Cartesian Product

Creating Equi Joins

Testing Equi Joins in Desktop Intelligence

Manual Creation of Joins

Detecting Joins

Creating Outer Joins

Creating Theta Joins

Measure Objects

Creating Measure Objects

Testing Measure Objects

Understanding and Resolving Loops

Creating a Loop

Testing Loops in Desktop Intelligence

Resolving the Loop - Automatic Detection on Single Join

Resolving the Loop - Automatic Detection on Whole Universe Structure

Resolving loops using aliases

Creating an alias Automatically

Creating an alias Manually

Finding and Re-Defining Aliased Table Objects

Testing Re-Defining Aliased Table Objects in User Module

Resolving Loops -  Recursive Table Structures

Recursive Joins

Testing Recursive Joins in Desktop Intelligence

Resolving loops using contexts

Creating Loops

Creating contexts

Testing Context In Desktop Intelligence

Testing  Incompatible Objects Query In Desktop Intelligence

Testing Ambiguous Query In Desktop Intelligence

Editing Ambiguous Query Reservation Line

Testing Ambiguous Query with Meaningful Information

Applying Restrictions on Objects

Restricting Data Dimension Objects

Restricting Data Measure Objects

Condition Objects

Condition Objects-Testing in User Module

Restricting Data Additional Joins

Creating Prompts

Testing Creating Prompts In Desktop Intelligence

Creating Multiple Prompts

Testing Multi Prompts - Start Date

Creating Multiple Prompts-Begin Date

Testing  Multiple Prompts- Begin Date

Using Hierarchies

Creating Default Hierarchy

Testing Hierachy in Desktop Intelligence

Creating Time Hierarchies

Testing Hierarchy In Desktop Intelligence

Creating Time Hierarchy using DBMS Function

Testing Time DBMS HierarchyIn Desktop Intelligence

Custom Hierarchies

Testing Custom Hierarchies In Desktop Intelligence

Aggregate Awareness

Define Aggregate Awareness objects

Define Aggregate Awareness incompatibilities

Other uses of Aggregate Awareness

Managing Universes

Documenting Universes

Universe Deployment - Protecting Universes

Universe Deployment - Exporting Universes

Architecting Universes

Creating and Hiding Where Clause

Using Where Clause in Other Objects

Using Where Clause in Other Objects - Testing in Desktop Intelligence

Creating and Hiding Where Clause -Inheritance From Original Object

Creating and Hiding Where Clause -Inheritance Test in User Module

Using Select Clause in Other Objects

Creating the Core Universe

Creating the Sales Department Universe

Linking Core to Sales Universe

Editing Core Universe and Checking Inheritance
Including Universes