SAP BusinessObjects 4.1 Information Design Tool (IDT) BootCamp Training

Course #:WA2417

SAP BusinessObjects 4.1 Information Design Tool (IDT) BootCamp Training

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach BusinessObjects 4.x Information Design Tool concepts. Topics to be covered include universe creation, creating relational database connections,  creating Data Foundations,  Creating Business Layers,  Folders and objects, filters,  table aliases, aggregate awareness, viewing table keys, Publishing and Securing universes, index awareness, universe maintenance, and converting 3.x Universes (.unv’s) to 4.1 Information Design Tool universes (.unx’s).

Objective

Upon completion of this course, the participant will be able to:

  • Understand what the Information Design Tool Is
  • How to create Single and Multi Connection Universes
  • Creating Data Foundations
  • Creating Business Layer Views
  • Creating Folders and Objects
  • How to create Dimensions, Attributes and Measures
  • Creating Filters within the different layers
  • Implementing Aggregate Awareness
  • Using Queries to test the Model

Topics

  • IDT Overview
  • Creating Projects
  • Creating Connections
  • Creating the Data Foundation Layer
  • Data Foundation Details
  • Business Layer Basics
  • Attributes and Measures
  • Aggregate Awareness
  • Building Business Layer Filters
  • LOV’s, Parameters and @Functions
  • Publishing and Securing the universe
  • Converting 3.x universes
  • Addendum

Audience

This class is designed for technical analysts who are required to create the BusinessObjects 4.x Connections, Data Foundations and Business Layers as an interface to the data in a data warehouse, data mart, or database.

Duration

2 Days

Outline of SAP BusinessObjects 4.1 Information Design Tool (IDT) BootCamp Training

IDT Overview

  • Basic Architecture
  • Infrastructure
  • Defining Layers
  • Definitions Review
  • Universe Development Process

Getting Started  

  • Defining Connections
  • Using the Connection Editor
  • Setting Connection Parameters
  • Creating Local Projects

Building Data Foundation Layer

  • Creating the Data Foundation
  • Using Data Foundation Editor
  • Inserting Database Tables
  • Viewing data in Table/Column
  • Detecting/Setting Keys
  • Profiling Column values
  • Inserting/Deleting Comments

Data Foundation Details

  • Defining Joins
  • Aliasing Tables
  • Setting/Deleting Column Filters
  • Creating Calculated Columns
  • Inserting Derived Tables
  • Creating Time Calculated Columns

Business Layer Basics

  • What is a Business Layer View
  • Creating Business Layers
  • Selecting Data Foundation
  • Building Folders and Dimensions

Attributes and Measures

  • What are Attributes?
  • Building Attributes in the Business Layer
  • What are Measures?
  • Building Measures in the Business Layer

Aggregate Awareness

  • Adding Summary tables into Data Foundation
  • Using @AggregateAware function
  • Detecting incompatible objects
  • Defining Aggregate Navigation

Query Objects and Testing

  • Building Query Objects
  • Testing the Business Layer
  • Integrity checking

Filters

  • Creating Filters
  • Object vs Universe Business Level Filters
  • Optional and Mandatory filter settings
  • Filter Testing

LOV’s, Parameters and @Functions

  • Creating and Implementing Custom List’s of Values
  • Creating and Implementing Parameters
  • Using @Prompt, @Select, @Where
  • Overview of @DerivedTable and @Variable

Publishing and Securing Universes

  • Publishing Universe
  • Understanding Security Profiles
  • Building Data Security Profiles
  • Building Business View Security Profiles
  • Profile Aggregation and Net Profiles
  • Testing, Editing and Deleting Profiles

Converting 3.x Universes  

  • How to Use Conversion Wizard
  • Reviewing changes to universe after conversion
  • Testing Universe after Conversion

Addendum  

  • Resolving Loops
  • Contexts in Business Layers and reasons for usage
  • Universes based on OLAP Cubes (SAP BW)
  • Testing Universes after Conversion
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.