SAP BusinessObjects Information Design Tool Training
SAP BusinessObjects Information Design Tool Training
· Basic SAP BusinessObjects Universe Design
o Describing Universes
o Working with Local Projects
· Data Connections
o Defining Connections
· Data Foundations
o Creating Data Foundations
o Using Joins
· Business Layers
o Accessing Data through the Business Layer
o Integrating the Business Layer Components
o Validating Objects
o Creating Measure Objects
· Shared Projects
o Using Shared Projects
o Manipulating Other Designers' Resources
· Universe Deployment
o Deploying a Universe
· Loops in a Data Foundation
o Creating Loops on the Data Foundation
o Resolving Loops Using Aliases
o Resolving Recursive Loops
o Resolving Loops Using Contexts
· Data Restrictions
o Defining Data Restrictions
o Applying Mandatory Data Restrictions
o Applying Optional Data Restrictions
· Lists of Values (LOVs)
o Defining a List of Values
o Associating a List of Values to a Business Layer Object
· Parameters
o Creating and Using a Parameter
· Navigation Paths
o Defining and Creating Navigation Paths
· SQL Traps
o Defining SQL Traps
o Identifying a Chasm Trap
o Resolving a Chasm Trap
o Identifying a Fan Trap
o Resolving a Fan Trap
· Object @Functions
o Using @Functions in SQL
o Using the @AggregateAware function
o Using the @Select Function
o Using the @Where Function
o Using the @Execute Function
o Using the @Variable Function
· Extending the Data Foundation with Derived Tables and Calculated Columns
o Creating and Using Derived Tables
o Creating and Using Calculated Columns
· Universe Optimization
o Optimizing Universes
· Universe Management with Data Foundation and Business Layer Views
o Managing the Data Foundation Using Views
o Managing the Business Layer Using Views
· Universe Security
o Securing a Deployed Universe with Security Profiles
o Creating and Assigning Universe Security Profiles
o Identifying the Priority of Security Settings
o Updating a Deployed Universe
· Ambiguous Outer Join Resolution
o Resolving an Ambiguous Outer Join
· Universe Creation with Different Data Sources
o Identifying Different Data Sources
o Creating an OLAP Universe
o Creating a Universe from a BEx Query
o Creating a Multisource Universe
o Creating and Using Federated Tables
· Linked Universes
o Defining and Creating a Linked Universe
o Special Considerations of Linked Universes
o Managing Core Universes
o Prioritizing the Display of Tables Common to Multiple Core Data Foundations
o Including a Core Universe
· Universe Conversion
o Converting Existing unv Universes
· Universe Translation
o Deploying a Universe in Different Languages
· Advanced Data Manipulation in the Business Layer
o Using SQL to Manipulate Data