Got a question? Call 1800 853 276   |   
Business Applications Category Banner Image

SAP BusinessObjects Information Design Tool (BOID10)

  • Length 5 days
  • Price  $5368 inc GST
Course overview
View dates &
book now

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


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

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.


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.


Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.