SAP BusinessObjects Information Design Tool

Course Overview

• Basic SAP BusinessObjects Universe Design
     -Describing Universes
     -Working with Local Projects
• Data Connections
• Data Foundations
     -Creating Data Foundations
     -Using Joins
     -Creating and Using Derived Tables
• Business Layers
     -Accessing Data through the Business Layer
     -Integrating the Business Layer Components
     -Creating Measure Objects
     -Testing Objects
• 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
• 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
• Linked Universes
     -Defining and Creating a Linked Universe
     -Managing Core Universes
     -Including a Core Universe

Prerequisites

Essential:
   Working knowledge of SQL and relational, also OLAP database management systems, concepts, and structures.

Recommended:
   Basic knowledge of reporting with SAP BusinessObjects Web Intelligence or equivalent knowledge of how universes are used by the various SAP BusinessObjects analytics tools