“I appreciate the fact that we were able to easily deviate from the book when possible to cover more interesting & advanced topics. [Instructor] is very knowledgeable and honest about BO XI capabilities. Thanks.”
– John F, FedEx
“[Instructor] is very knowledgeable in this subject and is able to communicate information in an easy, understandable manner. I look forward to doing the advanced class…”
– Kimberley G, Rogers Wireless
“This instructor gets a 10 out of 10. He is brilliant and has the expertise and teaching methodology that makes this type of course fun and educational. Highly recommend for future courses!!! OUTSTANDING!!!!!!!!!!!”
– Attendee, Burger King Corporation
Course Description
This course is designed to provide the skills needed to create and maintain SAP Business Objects Universes. The course is focused on technical users to teach how to design universes that are efficient as well as user friendly for report creators. Students are also taught how to maintain and distribute the universes. The course provides a comprehensive coverage of universe development process and techniques, allowing developers to understand the issues that they may encounter in a real world scenario and how to tackle these problems.
Audience
This course is targeted for technical users that need to create and distribute SAP Business Objects universes for their SAP Business Objects deployments.
Objectives
After completing the course, students will be able to create effective and efficient universes for their SAP Business Objects users. Students will learn techniques such as creating connections, adding tables and joins, resolving loops, creating pre-defined conditions, distributing and maintaining universes and much more. Students will also be able to create advanced universes and understand techniques such as Multisource Universes, Multilingual Universes, OLAP Universes, SQL Traps, Advanced uses of @Aggregate_Aware function, Universe Parameters and more. The course provides extensive hands on workshops in order to reinforce topics taught.
Duration & Version
5 Days – 4.x
Prerequisites
Knowledge of report development with Web Intelligence is recommended. Also, working knowledge of databases and SQL is required.
Topics Covered
What are Universes
Data Sources
Universe Components
The Universe development process
Converting .UNV to .UNX
Starting a Project
Defining the connection
Connection types
Other Connection Parameters
Selecting the Connection
Adding Tables to the Universe
Structure
Join Types
Inserting/Modifying/Deleting Joins
Managing Folders and Sub-Folders
Managing Dimension Objects
Managing Attribute Objects
Understanding Measure Objects
Creating Measure Objects
Object Aggregation
Delegated Measures
Resolving Loops
Creating and Managing Alias
Creating and Managing Universe Contexts
Creating/Editing and Deleting
Pre-defined Conditions
Using Object Where Clause
Self-Restricting Joins
Other data restriction techniques
Understanding LOVs
Modifying LOVs
Creating Hierarchical List Of Values
Understanding Parameters
Creating and Using Parameters
Understanding Navigation Paths
Creating and Using Navigation Paths
What are @Functions
@Prompt
@Select
@Where
@Variable
What are Derived Tables
Creating Derived Tables
Understanding Index Awareness
Using Index Awareness
Universe Deployment
Documenting Universes
Understanding Restrictions
Add/Change/Delete Restrictions
Apply Restrictions to Users and Groups
Understanding Aggregate Awareness
The @Aggregate_Aware function
Implementing Aggregate Awareness
What are SQL Traps
Understanding and Resolving Chasm Traps
Understanding and Resolving Fan Traps
Implementing Dynamic Outer Joins using the @Aggregate_Aware function
User Selectable Outer Joins
Using Joins for Relative Date Objects
Dynamic Time Period Measures From Date Dimension Tables
Multisource Universes
OLAP Universes
Managing Multiple Business Layers
Managing Multiple Data Foundation Views
Data Foundation Families
Using Shared Projects
What are Advanced Objects
Using Numeric Functions
Using String Functions
Using Datetime Functions
Using System Functions
Using CASE Statements
Relative Date Objects
Begin SQL
End SQL
Join By SQL
ANSI92
Filter In From