Course announcements

  • In this course you explore the fundamental principles and common advanced options of SAP BusinessObjects universe design by creating relational universes. NOTE: This course is applicable for customers on the SAP BusinessObjects BI Platform version 4.2 or higher.

Course information

Content

  • Basic SAP BusinessObjects Universe Design
    • Describing Universes
    • Working with Local Projects
  • Data Connections
  • Data Foundations
    • Creating Data Foundations
    • Using Joins
    • Creating and Using Derived Tables
  • Business Layers
    • Accessing Data through the Business Layer
    • Integrating the Business Layer Components
    • Creating Measure Objects
    • Testing Objects
  • Universe Deployment
  • 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
    • Defining a List of Values
    • Associating a List of Values to a Business Layer Object
  • Parameters
  • 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 @Aggregate_Aware Function
    • Using the @Select Function
    • Using the @Where Function
    • Using the @Execute Function
    • Using the @Variable Function
  • 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
  • Linked Universes
    • Defining and Creating a Linked Universe
    • Managing Core Universes
    • Including a Core Universe

Goals

  • This course will prepare you to:
    • This course is designed to give you the necessary skills needed to work with the Information Design Tool.
    • The Information Design Tool enables designers to define and manipulate metadata from relational sources to create and deploy SAP BusinessObjects universes.
    • In this course you learn how to use data from a relational database system to design universes to be used with the SAP BusinessObjects BI client tools.

Audience

  • Application Consultant
  • Data Consultant / Manager
  • Database Administrator
  • Developer
  • Developer Consultant
  • System Administrator
  • System Architect
  • Technology Consultant

Prerequisites

Essential

  • Working knowledge of SQL and relational database management systems, concepts, 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

Course based on software release

  • SBOP BI Platform 4.3

Find a course date

Can't find a suitable date?

Booking for 1-2 people?

Make a request for us to schedule training around what works for you? We will do our best to consider your request.

Request a training date

Booking for 3+ people?

Our 3 to RUN initiative empowers you to schedule our chosen classroom training course or virtual SAP Live Class on a date that suits you. You need at least three confirmed participants to register and SAP will add it to your schedule.

Find out more