SAP BusinessObjects Information Design Tool (BOID10)

Description

This 5-day instructor-led course gives you the comprehensive skills needed to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes. In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools.

Why attend

After completing this course, you will be able to:

Create a meta data environment with the SAP BusinessObjects Information Design Tool

Manipulate meta data from relational and OLAP sources to create and deploy SAP BusinessObjects universes

Who should attend

Application Consultant

Data Consultant / Manager

Database Administrator

Developer

Developer Consultant

System Administrator

System Architect

Technology Consultant

Prerequisites

Working knowledge of SQL and relational databases, also OLAP database management systems concepts and structures (essential)

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

Outline

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

Optimzing 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 Lanugages

Advanced Data Manipuliation in the Business Layer

Using SQL to Manipulate Data