This five-day course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

This course is designed to give 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.

1

  • Basic SAP BusinessObjects Universe Design

  • Describing Universes
    Defining the Components of a Universe
2

  • Data Connections

  • Defining connections
3

  • Data Foundations

  • Creating Data Foundations
    Using Joins
4

  • Business Layers

  • Accessing Data through the Business Layer
    Integrating the Business Layer Components
    Validating Objects
    Creating Measure Objects
    Creating Shortcut Joins
5

  • Loops in a Data Foundation

  • Resolving Loops with Joined Tables
    Resolving Loops Using Aliases
    Resolving Loops Using Contexts
    Detecting Contexts
    Editing Contexts
    Testing Contexts
    Resolving Recursive Loops
6

  • Data Restrictions

  • Defining Data Restrictions
    Applying Mandatory Data Restrictions
    Applying Optional Data Restrictions
7

  • Lists of Values (LOV)

  • Providing a List of Values
8

  • Parameters

  • Illustrating Runtime Parameters
9

  • Object @functions

  • Using Object @functions in Queries
    Applying the Aggregate Awareness Optimization Method
    Using Other @ Functions
10

  • Navigation Paths

  • Defining Drill Down Navigation Paths
11

  • Derived Tables

  • Creating Derived Tables
12

  • Key Awareness

  • Defining Numeric Keys
13

  • Universe Management with Data Foundation and Business Layer Views

  • Managing a Universe using the Data Foundation View
    Managing a Universe using the Business Layer View
14

  • Universe Optimization

  • Optimizing Universes Using Parameters
15

  • Universe Deployment and Security

  • Deploying a Universe
    Securing a Published Universe
    Creating Data Security Profiles
    Creating Business Security Profiles
    Assigning Security Profiles to Users
    Identifying the Priority of Security Settings
    Updating a Published Universe
16

  • SQL Clause Processing Problems

  • Determining How the Order of SQL Clauses Affects Data Returned
    Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables
    Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
    Identifying Fan Traps
    Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
17

  • Outer Join Problem Resolution

  • Resolving an Ambiguous Outer Join Using @AggregateAware
18

  • Universe Creation from Different Data Sources

  • Identifying the Different Data Sources
    Creating an OLAP Universe
    Creating a Multi-source Universe
19

  • Shared Projects

  • Using Shared Projects
    Manipulating Other Designers' Resources
20

  • Universe Conversion

  • Converting Existing .unv Universes
21

  • Translation

  • Deploying Universes in Different Languages

Audience

The primary audience for this course are Application Consultants, Data Consultants/Managers, Developers, Program/Project Managers, and System Administrators.

Language

English

Prerequisites

The prerequisites for this course are as follows: Working knowledge of SQL and relational databases; OLAP database management concepts, systems, and structures.

$4,335

Length: 5.0 days (40 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
18
Dec
Monday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Loading...