This unique four-day SAP BusinessObjects Training: BI Universe Designer & Information Design Tool Bootcamp is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using 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 Business Objects universes.

All of our trainers are certified and enthusiastic about SAP BusinessObjects! The course is offered onsite or via live instructor-led virtual classroom. All delegates receive course materials and access to our licensed environment for hands-on labs.

Goals:

  • This course is designed to give you the comprehensive skills needed to work with the Information Design Tool.
  • In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools.

Audience:

  • Application Consultant
  • Data Consultant or Managers
  • Developer
  • Project managers
  • System Administrators

Prerequisites:

  • Working knowledge of SQL and relational databases
  • OLAP database management systems concepts and structures

Agenda:

Module 1: Basic SAP BusinessObjects Universe Design

  • Describing Universes
  • Defining the Components of a Universe

Module 2: Data Connections

  • Defining Connections

Module 3: Data Foundations

  • Creating Data Foundations
  • Using Joins

Module 4: Business Layers

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

Module 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

Module 6: Data Restrictions

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

Module 7: Lists of Values (LOV)

  • Providing a List of Values

Module 8: Parameters

  • Illustrating Runtime Parameters

Module 9: Object @functions

  • Using Object @functions in Querie

Module 10: Applying the Aggregate Awareness Optimization Method

  • Using Other @ Functions
  • Navigation Paths
  • Defining Drill Down Navigation Paths

Module 11: Derived Tables

  • Creating Derived Tables

Module 12: Key Awareness

  • Defining Numeric Keys

Module 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

Module 14: Universe Optimization

  • Optimizing Universes Using Parameters

Module 15: Outer Join Problem Resolution

  • Resolving an Ambiguous Outer Join Using @AggregateAware

Module 16: Translation

  • Deploying Universes in Different Languages

Module 17: Universe Conversion

  • Converting Existing .unv Universes

Module 18: 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

Module 19: 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

Module 20: Universe Creation from Different Data Sources

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

Module 21: Shared Projects

  • Using Shared Projects
  • Manipulating Other Designers’ Resources
Print Friendly, PDF & Email