COURSE DETAILS & CURRICULUM
- 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