SAP BusinessObjects Information Design Tool



In this course, you will gain the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool. You will learn how to work with the Information Design Tool, which 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.

This course is based on software release SBOP BI PLATFORM 4.1.


  • Application consultant
  • Data consultant / manager
  • Developer
  • Program / project manager
  • System administrator


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

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