SAP BusinessObjects Information Design Tool

Course Content

• Basic SAP BusinessObjects Universe Design
     -Describing Universes
     -Working with Local Projects
• Data 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
• 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
     -Defining a List of Values
     -Associating a List of Values to a Business Layer Object
• Parameters
• 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 @Aggregate_Aware 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
• 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
• Universe Creation with Different Data Sources
     -Identifying Different Data Sources
     -Creating an OLAP Universe
     -Creating a Universe from a BW Query
     -Creating a Multisource Universe
     -Creating and Using Federated Tables
• Linked Universes
     -Defining and Creating a Linked Universe
     -Special Considerations Concerning Linked Universes
     -Managing Core Universes
     -Prioritizing the Display of Tables Common to Multiple Core Data Foundations
• Universe Conversion
• Working with Sets
• Universe Translation
• Advanced Data Manipulation in the Business Layer

Course based on software release

• SBOP BI Platform 4.3