SAP BusinessObjects Information Design Tool

5 Days

Description

Skills Gained

  • This course will prepare you to: 
       -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 delpoy SAP BusinessObjects universes. 
       -In this course you will create a relational universe based on a standard relational database.

Who Can Benefit

  • Application Consultant
  • Data Consultant / Manager
  • Developer
  • Program / Project Manager
  • System Administrator
  • Technology Consultant

Upcoming Classes

Virtual Classroom Live
October 09, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
October 23, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
December 11, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
December 18, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • Basic SAP BusinessObjects Universe Design
    • Describing Universes
    • Defining the Components of a Universe
  • 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
    • Creating Shortcut Joins
  • 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
  • Data Restrictions
    • Defining Data Restrictions
    • Applying Mandatory Data Restrictions
    • Applying Optional Data Restrictions
  • Lists of Values (LOV)
    • Providing a List of Values
  • Parameters
    • Illustrating Runtime Parameters
  • Object @functions
    • Using Object @functions in Queries
    • Applying the Aggregate Awareness Optimization Method
    • Using Other @ Functions
  • Navigation Paths
    • Defining Drill Down Navigation Paths
  • Derived Tables
    • Creating Derived Tables
  • Key Awareness
    • Defining Numeric Keys
  • 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
  • Universe Optimization
    • Optimizing Universes Using Parameters
  • 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
  • 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
  • Outer Join Problem Resolution
    • Resolving an Ambiguous Outer Join Using @AggregateAware
  • Universe Creation from Different Data Sources
    • Identifying the Different Data Sources
    • Creating an OLAP Universe
    • Creating a Multi-source Universe
  • Shared Projects
    • Using Shared Projects
    • Manipulating Other Designers' Resources
  • Universe Conversion
    • Converting Existing .unv Universes
  • Translation
    • Deploying Universes in Different Languages

Upcoming Classes

Virtual Classroom Live
October 09, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
October 23, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
December 11, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
December 18, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Essential:

-Working knowledge of SQL and relational, also OLAP database management systems, concepts, and structures. 
   -Basic knowledge of reporting with SAP BusinessObjects Web Intelligence. 
   -OLAP database management concepts, systems and structures

Recommended: 
   -SAP BusinessObjects Business Intelligence 4.0 
   -SAP BusinessObjects Information Design Tool BI 4.0

Upcoming Classes

Virtual Classroom Live
October 09, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
October 23, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
December 11, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
December 18, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Comments

none

Upcoming Classes

Virtual Classroom Live
October 09, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
October 23, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
December 11, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Virtual Classroom Live
December 18, 2017

$3,350.00
5 Days    9:30am EST - 5:30pm EST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date