BO3UD – BusinessObjects XIR3 Universe Design

Enquire/Book this course

  • This field is for validation purposes and should be left unchanged.
Print this page
  • Code: BO3UD
  • Duration: Days 3
  • Price per delegate: £1,500 +VAT

Trained over 60000 delegates

Course delivered by industry expert instructors

Highly competitive pricing

 

Course Description
BusinessObjects Universe Design provides all the skills needed to design, build and maintain XI R3 universes. Delegates will learn universe design concepts and terminology as well as the role of universes in relation to BusinessObjects reporting tools.
This course introduces basic universe design concepts, planning strategies, and then leads delegates through the design and creation of a universe that responds to defined user requirements. Delegates will learn to identify and avoid common universe structural problems and include useful end-user functionality, thereby creating maintainable universes that offer optimal usability.
A detailed manual is provided with this course and workshops at the end of each section give an opportunity to practice what has been learned.

Target Student: This course is designed to teach you how to design BusinessObjects Universes using Universe Designer, BusinessObjects XI R3.

Prerequisites:
           Familiarity with BusinessObjects Web Intelligence report building
           A good understanding of relational databases and client-server concepts
           Basic understanding of SQL

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Course Content

1. Introduction to Universe Design
Understanding how universes allow users to query databases using their everyday business terms
 
2. Creating the Course Universe
The course database and universe
Creating the universe
 
3. Building the Universe Structure
Populating the universe structure
Defining joins in a universe
 
4. Dimension Objects
Understanding classes and objects
Creating classes and dimension objects
 
5. Measure Objects
Understanding measure objects
Creating measure objects
Delegated Measures
 
6. Using Lists of Values
Working with LOVs in Universe Designer
Creating a cascading LOV
Creating a List of Values
7. Understanding and Resolving Loops
Understanding loops
Resolving loops using aliases, shortcut joins and contexts
 
8. SQL Traps
Understanding SQL traps and universes
Detecting and resolving chasm traps
Detecting and resolving fan traps
 
9. Restrictions and Condition Objects
Restricting the data returned byobjects
 
10. Using Functions
Using @ Functions
 
 
11. Using Hierarchies
Understanding hierarchies and universes
Working with hierarchies
 
12. Derived Tables
Using derived tables
 
13. End-of-Course Challenge
End-of-course challenge exercise