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)
Code: BOID10
Price: 3.625 EUR

Inquire about this course

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Related articles

Coronavirus (COVID-19)

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

Dates

08 Jun12 Jun
Virtual Live CET Time
Sold out!
27 Jul31 Jul
's-Hertogenbosch
Sold out!
16 Nov20 Nov
Brussels
Sold out!

Pricing

The fee for this 5-day course is EUR 3.625,00 (+VAT) per person.

Copyright ©2020 quest for knowledge