Business Objects 5/6 Designer Course

Course Code: BO 03
Course Abstract: This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Business Objects 5/6 Designer concepts. Topics to be covered include Universe Creation, Database Connection, Joins, Classes and Objects, Hierarchies, Loop resolution, Contexts, Aliases, Aggregate Awareness, Predefined Conditions, Restrictions, Universe Maintenance and Documenting and Distributing Universes.

 

Audience: This class is designed for technical analysts that are required to create the Business Objects 5/6 semantic layer as an interface to the data in a company data warehouse, datamart or database.
Duration: 2 days
Learning Outcomes:

Upon completion of this course, the participant will be able to:
> Create and Maintain Universes
> Detect Join Cardinality and Connect Database Tables
> Create Classes and Objects within Hierarchies
> Define Dimensions, Details and Measures
> Resolve Loops and Traps Using Contexts and Aliases
> Create Predefined Conditions
> Use Business Objects 5/6 Reporting Tool to Test Universes and SQL Creation

Course Topics:

Business Objects Overview
Basic Architecture
Administration
Semantic Layer
Definitions Review
Universe Development Process

Getting Started
Using Designer
Defining Database Connection
Setting Parameters
Inserting Database Tables

Joins
Defining Joins
Methods of Creating Joins
Creating Equi-Joins

Creating Outer Joins
Creating Theta Joins
Detecting Joins

Classes and Objects
Defining Classes/Subclasses
Defining Object Types
Class and Object Orientation
Creating Classes
Creating Dimensions/Details
Object Properties
List of Values
Deleting Objects
Testing Cycle

Measures
Creating Measures Class
Creating Simple Measures
Creating Measures Using Arithmetic Formula
Formatting Measures
Resolving Loops
Using Aliases
Using Contexts
Checking

Restrictions
Forced Restrictions
Object Level Restrictions
Self Restricting Joins
Conditional Select Statements
Additional Inferred Joins
Optional Restrictions
@Functions
@Prompt
@Select
@Where
@Variable
@Script

Hierarchies
Hierarchy Types
Default Hierarchies
Automatic Time Hierarchies
Table Based Time Hierarchies
Custom Hierarchies

Aggregate Awareness
Summary Tables
Applying Aggregate Awareness
@Aggregate Aware
Detecting Incompatibility

Resolving Traps
Fan Traps/Chasm Traps
Procedure For Resolving Traps

Documenting & Maintaining Universes
Documenting Universes
Creating Hardcopy (Printing)
Distributing Universe
Universe Security
Enterprise Distribution
Exporting Universes
Locking Universes
Incremental Exports
Version Control
Maintaining Universes
Target Database Changes
Impact Resolution
Adding New Tables
Object Revisions
Efficient Maintenance

Prerequisites:

Basic Windows 95/98/NT skills.
Some Database Background
Some SQL Skills
Business Objects 5/6 Basic Reporting

Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning