About this Course

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 updated version of Course BOID10 participants will learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools

Audience Profile

This course is intended for the following audiences:

• Application Consultants / Data Consultants / Data Managers
• Senior BI Project Managers
• BusinessObjects System Administrators
• Senior BI Developers or Content Creators

Prerequisites

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

Course Outline

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 Throught the Business Layer
• Integrating the Business Layer Components
• Validating and Testing Objects
• Creating Measure Objects
• Creating a Delegated Measure
• Creating Shortcut Joins

5. Loops in Data Foundation

• Resolving Loops with Joined Tables
• Resolving Loops Using Aliases
• Resolving Loops Using Contexts
• Destecting Contexts
• Editing and Testing Contexts
• Resolving Recursive Loops

6. Data Restrictions

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

7. List of Values

• Providing a List of Values
• Associating Values with a Business Object

8. Parameters

• Illustrating Runtime Parameters
• Data Foundation Parameters

9. Objects @functions

• Using Object @functions
• Applying Aggregate Awareness Optimization Method
• Using Other Functions
• @select, @where, @execute

10. Relative Time Objects

• Creating Time Objects

11. Navigation Paths

• Defining and Using Drill Down Navigation Paths

12. Derived Tables

• Creating and Using  Derived Tables

13. Key Awareness

• Defining and Setting Up Numeric Keys

14. Universe Management

• Data Foundation View
• Business Layer View

15. Universe Optimization

• Optimizing Universes Using Parameters
• Editing Query Script Parameters

16. Universe Deployment & Security

• Deploying a Universe
• Securing a Published Universe
• Creating A Data Security Profile
• Creating Business Security Profile
• Identifying Priority to User Security Settings
• Updating a Published Universe

17. SQL Clause Processing

• Identifying SQL Clause Problems
• Determingin How the Order of SQL Clauses Affects Results
• Detecting and Resolving Chasms
• Identifying and Resolving Fan Traps

18. Outer Joins

• Resolving Outer Join Problems
• Resolving Ambiguous Outer Joins with @AggregateAware

19. Creating Universes from Different Data Sources

• Creating OLAP Universes
• Creating Multi-source Universes
• Using Federated Tables

20. Shared Projects

• Using Shared Projects
• Manipulating Another Designer’s Resources
• Synchronizing a Project
• Reviewing and Merging Changes to a Shared Project

21. Conversions

• Convertng a .UNV to a .UNX Universe

22. Languages & Translation

• Deploying a Universe in Different Languages