DURATION
3 Days
Course 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.
Who should attend?
This three-day instructor-led course is designed for universe designers, new to BusinessObjects Designer, who need to design, build, document, maintain, and distribute BusinessObjects universes.
What will I learn?
To design, optimize and maintain universes that reflect the reporting needs of end users in your organization.
Topics Covered
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 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
Managing Universes
Documenting universes
Deploying universes
Maintaining universes
Certification Applicability
This course is not part of a certification path.
Prerequisites
A solid understanding of relational databases and client-server concepts. Must be SQL-literate.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.