SAP BUSINESSOBJECTS INFORMATION DESIGN TOOL TRAINING

Basic SAP BusinessObjects Universe Design

• Describing Universes
• Working with Local Projects

Data Connections

• Defining Connections

Data Foundations

• Creating Data Foundations
• Using Joins

Business Layers

• Accessing Data through the Business Layer
• Integrating the Business Layer Components
• Validating Objects
• Creating Measure Objects

Shared Projects

• Using Shared Projects
• Manipulating Other Designers' Resources

Universe Deployment

• Deploying a Universe

Loops in a Data Foundation

• Creating Loops on the Data Foundation
• Resolving Loops Using Aliases
• Resolving Recursive Loops
• Resolving Loops Using Contexts

Data Restrictions

• Defining Data Restrictions
• Applying Mandatory Data Restrictions
• Applying Optional Data Restrictions

Lists of Values (LOVs)

• Defining a List of Values
• Associating a List of Values to a Business Layer Object

Parameters

• Creating and Using a Parameter

Navigation Paths

• Defining and Creating Navigation Paths

SQL Traps

• Defining SQL Traps
• Identifying a Chasm Trap
• Resolving a Chasm Trap
• Identifying a Fan Trap
• Resolving a Fan Trap

Object Functions

• Using Functions in SQL
• Using the AggregateAware function
• Using the Select Function
• Using the Where Function
• Using the Execute Function
• Using the Variable Function

Extending the Data Foundation with Derived Tables and Calculated Columns

• Creating and Using Derived Tables
• Creating and Using Calculated Columns

Universe Optimization

• Optimizing Universes

Universe Management with Data Foundation and Business Layer Views

• Managing the Data Foundation Using Views
• Managing the Business Layer Using Views

Universe Security

• Securing a Deployed Universe with Security Profiles
• Creating and Assigning Universe Security Profiles
• Identifying the Priority of Security Settings
• Updating a Deployed Universe

Ambiguous Outer Join Resolution

• Resolving an Ambiguous Outer Join

Universe Creation with Different Data Sources

• Identifying Different Data Sources
• Creating an OLAP Universe
• Creating a Universe from a BEx Query
• Creating a Multisource Universe
• Creating and Using Federated Tables

Linked Universes

• Defining and Creating a Linked Universe
• Special Considerations of Linked Universes
• Managing Core Universes
• Prioritizing the Display of Tables Common to Multiple Core Data Foundations
• Including a Core Universe

Universe Conversion

• Converting Existing unv Universes

Universe Translation

• Deploying a Universe in Different Languages

Advanced Data Manipulation in the Business Layer

• Using SQL to Manipulate Data