Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > SAP > SAP BusinessObjects 4.1 Information Design Tool (IDT) BootCamp Training

SAP BusinessObjects 4.1 Information Design Tool (IDT) BootCamp Training

Course#: WA2417

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 WA2417 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.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.