Business Applications Category Banner Image

SAP BusinessObjects Information Design Tool (BOID10)

Length 4 days
Price $4664 inc GST

Course overview

View dates &
book now

Why study this course

This four-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

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 Lumify Work

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

View all SAP at Lumify Work courses

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

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

Terms & Conditions

The supply of this course by Lumify Work 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.