Got a question? Call 1800 853 276   |   

BOID10 – SAP BusinessObjects Information Design Tool

  • Length 5 days
  • Price $6600 inc GST
Course overview
View dates &
book now
  • Register interest

Why study this course

This five-day instructor-led 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.

You’ll also 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.2

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.


What you’ll learn

This course will prepare you to:

  • work with the Information Design Tool

  • extract, define, and manipulate metadata from relational and OLAP sources

  • create and deploy SAP BusinessObjects universes

  • use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools


SAP at DDLS

Develop your SAP empowered employees with DDLS. Getting the right skills in place maximises the chance of project success and removes risk. DDLS provides a select range of SAP training courses for SAP S/4HANA, SAP HANA, SAP BusinessObjects and more. DDLS can work with you to navigate the curriculum and help you create a learning plan that will ultimately boost technology proficiency across your organisation.


Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

  • Application Consultant

  • Data Consultant/Manager

  • Database Administrator

  • Developer

  • Developer Consultant

  • System Administrator

  • System Architect

  • Technology Consultant


Course subjects

Basic SAP BusinessObjects Universe Design

  • Describing Universes

  • Working with Local Projects

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

Shared Projects

  • Using Shared Projects

  • Manipulating Other Designers’ Resources

Universe Deployment

  • Deploying a Universe

Loops in a Data Foundation

  • Creating Loops on the Data Foundation

  • Resolving Loops Using Aliases

  • Resolving Recursive Loops

  • Resolving Loops Using Contexts

Data Restrictions

  • Defining Data Restrictions

  • Applying Mandatory Data Restrictions

  • Applying Optional Data Restrictions

Lists of Values (LOVs)

  • Defining a List of Values

  • Associating a List of Values to a Business Layer Object

Parameters

  • Creating and Using a Parameter

Navigation Paths

  • Defining and Creating Navigation Paths

SQL Traps

  • Defining SQL Traps

  • Identifying a Chasm Trap

  • Resolving a Chasm Trap

  • Identifying a Fan Trap

  • Resolving a Fan Trap

Object @Functions

  • Using @Functions in SQL

  • Using the @AggregateAware function

  • Using the @Select Function

  • Using the @Where Function

  • Using the @Execute Function

  • Using the @Variable Function

Extending the Data Foundation with Derived Tables and Calculated Columns

  • Creating and Using Derived Tables

  • Creating and Using Calculated Columns

Universe Optimisation

  • Optimising Universes

Universe Management with Data Foundation and Business Layer Views

  • Managing the Data Foundation Using Views

  • Managing the Business Layer Using Views

Universe Security

  • Securing a Deployed Universe with Security Profiles

  • Creating and Assigning Universe Security Profiles

  • Identifying the Priority of Security Settings

  • Updating a Deployed Universe

Ambiguous Outer Join Resolution

  • Resolving an Ambiguous Outer Join

Universe Creation with Different Data Sources

  • Identifying Different Data Sources

  • Creating an OLAP Universe

  • Creating a Universe from a BEx Query

  • Creating a Multisource Universe

  • Creating and Using Federated Tables

Linked Universes

  • Defining and Creating a Linked Universe

  • Special Considerations of Linked Universes

  • Managing Core Universes

  • Prioritising the Display of Tables Common to Multiple Core Data Foundations

  • Including a Core Universe

Universe Conversion

  • Converting Existing .unv Universes

Universe Translation

  • Deploying a Universe in Different Languages

Advanced Data Manipulation in the Business Layer

  • Using SQL to Manipulate Data


Prerequisites

Essential

  • Working knowledge of SQL and relational databases

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

Recommended

  • Basic knowledge of reporting with SAP BusinessObjects Web Intelligence or equivalent knowledge of how universes are used by the various SAP BusinessObjects analytics tools


THIRD PARTY REGISTRATION

DDLS offers certification and training through our partnership with SAP Inc. This arrangement requires DDLS to provide your details to SAP Inc for course and exam registration purposes.


Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.



Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.