SAP BusinessObjects Web Intelligence 4.2 Report Design Level 2

545.00 $

Delivery Type: The Course is taken online
Length of Access: 1 year
Features: 24/7 Access, Real Instructors, Classroom Materials and Exercise Guides. Exam Prep and Instructor Support.

Online Classes

Flexible Schedule


High Quality


Instructor Help



SAP BusinessObjects Web Intelligence 4.2, the latest version of the software, is a big change from the previous version.  Because of the large number of new features in v4.2, we estimate 75% or more of v4.2 is brand new, getting trained in v4.2 is critical.  V4.2 contains features unlike any you have ever seen before.  In fact, it is almost like starting over.

The new software allows you to build more extensive and complex reports utilizing the many new features.  You will learn how to create very cool visualizations utilizing just Web Intelligence and not have to use any other product.  You will create documents with multiple data sources including Excel and FreeHand SQL as well as learn how to update Excel data sources.

The learning curve on the new software is steep.  In SAP BusinessObjects Web Intelligences Report Design Level 1 and Level 2 classes, taught by SAP BusinessObjects Web Intelligence Reporting Expert, Michael Ward, you will bypass the wasted hours of trial and error and learn how to utilize all the new features, review potential application uses and understand how to bypass all the pitfalls.  In addition, all students will receive a 50 page v4.2 SP3 User Guide.

The SAP BusinessObjects Web Intelligence v4.2 training program consists of two courses:  (1) SAP BusinessObjects Web Intelligence Report Design Level 1 and (2) SAP BusinessObjects Web Intelligence Report Design Level 2.  Please note that Report Design Level 1 or equivalent knowledge is required before you can take Report Design Level 2.

SAP BusinessObjects Web Intelligence™ 4.2 Report Design Level 2  you will learn about formulas, variables and functions, multiple data providers, advanced query filters, subqueries, drilling on reports, cross tables and charts, combination queries.  Michael will show you how to create formulas, and then convert those formulas to variables. You will learn how to create complex variables using the extensive function library, how to add multiple data providers to a document and how to merge the dimensions so the report objects synchronize properly.  Michael will teach you how perform data mining by using the drilling functionality.   You will also learn how to hide objects, blocks and cells, how to hide sections in a report, and how to link reports and charts.  There will be lab exercises throughout the course to help you practice what you’ve learned.  Lab exercises require an in-house server running SAP BusinessObjects. Lab exercises are also demonstrated throughout the entire course.

In This Course You Will Learn:

As a result of taking this course, you will be able to:

  • Create formulas and variables
  • Build advanced queries
  • Access multiple data providers
  • Merge multiple data providers
  • Create combination queries
  • Create drillable reports
  • Revise SQL in existing reports


SAP BusinessObjects Web Intelligence 4.2 Report Design Level 1


Module 00: Web Intelligence 4.2 Advanced Reporting – Course Introduction

Module 01: Creating Formulas and Variables

  • Creating A Formulas
  • Creating Variables
  • Editing Variables

Module 01a: Creating Formulas and Variables Demo

Module 02: Function Categories

  • Using Functions in Variables
  • Using the Online Help
  • Using Context Operators
  • Shared Elements

Module 02a: Function Categories Demo

Module 03: Creating Formulas and Variables in a Report Exercise

Module 04: Adding Queries

  • Adding New Queries
  • Duplicating Queries
  • Deleting Queries

Module 04a: Adding Queries Demo

Module 05: Merging Dimensions

  • Merging Dimensions to Link Data Providers
  • Creating Single Block Reports
  • Auto Merging

Module 05a: Merging Dimensions Demo

Module 06: Creating Reports from Multiple Data Providers Exercise

Module 07: Subqueries

  • Object to Object Filters
  • Subquery Any
  • Subquery All

Module 07a: Subqueries Demo

Module 08: Query Within Query

  • Filters Based on Previous Queries

Module 08a: Query Within Query Demo

Module 09: Advanced Query Filters Exercise

Module 10: Drilling Part 1

  • Setting Drill Preferences
  • Hierarchies
  • Drilling Down/Up/Through

Module 10a: Drilling Part 1 Demo

Module 11: Drilling Part 2

  • Using Scope of Analysis
  • Snapshots
  • Drill Mode

Module 11a: Drilling Part 2 Demo

Module 12: Report Drilling Exercise

Module 13: Combination Queries

  • Union Queries
  • Intersect Queries
  • Minus Queries

Module 13a: Combination Queries Demo

Module 14: Combination Queries Exercise

Module 15: Advanced Formatting

  • Hiding Objects
  • Conditionally Hiding Blocks and Cells
  • Conditionally Hiding Sections

Module 15a: Advanced Formatting Demo

Module 16: Linking Reports and Creating Web Services

  • Linking Reports
  • Linking Charts
  • Creating and Publishing Web Services

Module 16a: Linking Reports and Creating Web Services Demo

Module 17: Advanced Formatting Exercise


The SAP Certified Application Associate™ – SAP BusinessObjects Web Intelligence 4.2 Certification exam verifies your skills and knowledge of SAP BusinessObjects Web Intelligence 4.2.  In the exam you are tested on your knowledge of maintaining queries and reports.

In the SAP Certified Application Associate exam you will be tested on your knowledge creating queries, report design, analysis of data and document sharing.  SAP recommends that you prepare for the exam through education courses and hands-on experience.  You are not allowed to use any reference materials when you are taking the exam and that includes no access to online documentation or to any SAP system.

GogoTraining’s two course series, SAP BusinessObjects Web Intelligence Report Design Level 1 and SAP BusinessObjects Web Intelligence Report Design Level 2 have been designed to cover all content that is included in the SAP recommended courses below:

  • Web Intelligence – Report Design I, BOW310 (SBOP Bi Platform 4.2)
  • Web Intelligence – Report Design II, BOW320 (SBOP Bi Platform 4.2)

The SAP Certified Application Associate™ – SAP BusinessObjects Web Intelligence 4.0 Certification exam is an 80 question exam and you may take up to 180 minutes (3 hours) to complete it. A passing mark is 63% or higher. The exam number is C_BOWI_42.

Topics Covered in the exam include:

  • Webl Formulas and Variables – 12%
  • Query Filters – 12%
  • Webl Query Creation and Usage – 12%
  • Webl Document Management – 8 to 12%
  • Webl Document Design – 8 to 12%
  • Hyperlinks in Webl Documents –  <8%
  • Drilling Functionality – <8%
  • Webl Document Formatting – <8%
  • Web Intelligence (Concepts) – <8%


Click on this link to find out more about the exam and to find exam locations.

Special offer


There are no reviews yet.

Be the first to review “SAP BusinessObjects Web Intelligence 4.2 Report Design Level 2”

Your email address will not be published. Required fields are marked *

Select your currency