Business Objects XI Designer Course

Course Code: BO 38
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 XI Universe Design concepts. Topics to be covered include universe creation, creating database connections, joins, classes and objects, hierarchies, loop resolution, contexts, table aliases, aggregate awareness, viewing table keys, creating predefined conditions, restrictions, universe maintenance, and universe distribution/documentation.

Free BusinessObjects User Group Meeting available when you schedule this course.

Audience: This class is designed for technical analysts who are required to create the Business Objects XI semantic layer as an interface to the data in a data warehouse, data mart, or database.
Duration: 2 days
Learning Outcomes:

Upon completion of this course, the participant will be able to:
> Create and Maintain Universes
> Join Database Tables and Set or Detect Join Cardinality
> Create Classes and Objects within Hierarchies
> Define Dimensions, Details, and Measures
> Using Contexts and Aliases
> Create Predefined Conditions
> Use Web Intelligence XI Reporting Tool to Test Universes and SQL Generation

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
User / Group 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
@AggregateAware
Detecting Incompatibility

Resolving Traps
Fan Traps/Chasm Traps
Procedures for Resolving Traps

Documenting & Maintaining Universes
Documenting Universes
Creating Hardcopies (Printing)
Saving As PDF
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
Using Group/Object/SQL Find Functionality
Efficient Maintenance

Prerequisites:

Basic Windows 95/98/NT/2000/XP skills
Some Database Background
Some SQL Skills
Business Objects XI WebIntelligence 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