SAP BusinessObjects Information Design Tool 

“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

Overview

What are Universes
Data Sources
Universe Components
The Universe development process
Converting .UNV to .UNX

Getting Started

Starting a Project
Defining the connection
Connection types
Other Connection Parameters

Creating the Data Foundation

Selecting the Connection
Adding Tables to the Universe
Structure
Join Types
Inserting/Modifying/Deleting Joins

Creating the Business Layer

Managing Folders and Sub-Folders
Managing Dimension Objects
Managing Attribute Objects

Measure Objects

Understanding Measure Objects
Creating Measure Objects
Object Aggregation
Delegated Measures

Loops

Resolving Loops
Creating and Managing Alias
Creating and Managing Universe Contexts

Restricting Data

Creating/Editing and Deleting
Pre-defined Conditions
Using Object Where Clause
Self-Restricting Joins
Other data restriction techniques

List of Values & Parameters

Understanding LOVs
Modifying LOVs
Creating Hierarchical List Of Values
Understanding Parameters
Creating and Using Parameters

Creating Navigation Paths

Understanding Navigation Paths
Creating and Using Navigation Paths

@Functions

What are @Functions
@Prompt
@Select
@Where
@Variable

Derived Tables & Index Awareness

What are Derived Tables
Creating Derived Tables
Understanding Index Awareness
Using Index Awareness

Maintenance and Deployment

Universe Deployment
Documenting Universes
Understanding Restrictions
Add/Change/Delete Restrictions
Apply Restrictions to Users and Groups

Aggregate Awareness

Understanding Aggregate Awareness
The @Aggregate_Aware function
Implementing Aggregate Awareness

SQL Traps

What are SQL Traps
Understanding and Resolving Chasm Traps
Understanding and Resolving Fan Traps

Advanced use of @Aggregate_Aware Function

Implementing Dynamic Outer Joins using the @Aggregate_Aware function
User Selectable Outer Joins

Advanced Join Techniques

Using Joins for Relative Date Objects
Dynamic Time Period Measures From Date Dimension Tables

Creating Universes from Different Data Sources

Multisource Universes
OLAP Universes

Managing Universes

Managing Multiple Business Layers
Managing Multiple Data Foundation Views
Data Foundation Families
Using Shared Projects

Managing Universes

What are Advanced Objects
Using Numeric Functions
Using String Functions
Using Datetime Functions
Using System Functions
Using CASE Statements
Relative Date Objects

Universe SQL Parameters

Begin SQL
End SQL
Join By SQL
ANSI92
Filter In From

 

Download Course Description Contact Us

For More Information

Toll Free: 1-888-887-2464

Email: training@compuexcel.com

Website: http://compuexcel.com

Prefer Custom Training? 

Contact us for any Customized training needs.