SAP BusinessObjects Web Intelligence 4.2 Report Design Level 2

This course covers SAP BusinessObjects Web Intelligence (Webi) Report Design using SAP BI Platform 4.2, the latest release by SAP.  In this release over 75% of the content has changed.  If you need to get up to speed quickly and efficiently on Webi Reporting v4.2, then this is the perfect solution for you and your team.

Online Classes

High Quality

Flexible Schedule

Certifications

Interactive

Instructor Help

High Success Rate

Extra Resources

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

Prerequisites

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%

 

EXAM LOCATION

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

Course

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.

$429.00Add to cart

Having issues playing videos?

Meet Your Instructor

Michael Ward

Michael Ward has over 10 years of experience with BusinessObjects.  He provides consulting and training services to customers throughout the world.  He is a frequently requested speaker at BusinessObjects User Group Meetings throughout North America.  Most recently, Michael presented at the BusinessObjects International User Group Meeting in Dallas, where he did 2 major presentations.  Michael Ward has over 26 years of FOCUS experience and over 25 years in consulting and training.  He has operating systems experience on a variety of platforms, including VM/CMS, MVS/TSO, VAX/VMS, AS/400, HP/UNIX, SQL/Server, PC/DOS, Windows NT/Server and many others.  For over three (3) years, from its inception, he was a presenter of a variety of topics at the Top Gun School for High Performance.  He taught all levels of FOCUS training classes, and was also a Train-The-Trainer.  Because of Michael’s extensive application experience and FOCUS technical skills, he provided high level consulting throughout the Midwest.  Michael has also worked with the FOCUS interface to DB2, SQL/DS, RDB, TERADATA, ORACLE, AS/400, and other products.  He is a certified ORACLE Master in Application Development.   He also has training and application experience in CACTUS/WebFOCUS.

He has spoken to numerous FOCUS user groups throughout the country, and has also been heavily involved with training organizations throughout the Midwest.  Michael has done training presentations many times to the Detroit Area Trainers Association and the Northern Ohio Data Trainers Association.  He has also spoken at the national FUSE Conference several times.  At the 1993 FUSE Conference in Atlanta, Michael was voted “Best Session”.  He was the keynote speaker for the Detroit Area Trainers Association all day symposium several years ago.  He has received numerous references from customers throughout the country.  Michael holds a B.S. in Mathematics from the University of Michigan.

Michael is a major supporter of Community Living Toronto, an organization that support  intellectually (and physically) challenged adults.  He sponsors annual overnight trips for groups from Toronto to attend various sporting events in the Detroit area, and helps cover the costs for the groups.

System Requirements

Hardware:  

  • In-house server capable of handling SAP BusinessObjects

Software:

  • SAP BusinessObjects installed on the server
  • 3 required exercise files downloaded and installed on the server (20 minute download), provided in the Course Materials tab

IMPORTANT NOTE: Only administrative level Server and BusinessObjects account access will have the security rights to install and setup the database files, the workshop files, connections and universes.

Get Your Course Maetrials

When you purchase this course you will receive access to these materials.

  • Student Guide
  • Exercise Guide
  • Workshops
  • Exercise Databases
  • Exercise .lcmbiar File
  • WEBI Classware Installation Instructions
  • Webi Enhancements v4.2 SP 8
  • Charting v4.2
  • New Features Addendum Webi v4.2 SP 8

Course Links

These links are activated when you purchase this course.

  • Course Survey

Course Transcript

This course comes with a Transcript that tracks your progress. You can use your transcript to view and monitor your progress and when you complete the course, you can print or email the transcript.

Letter of Course Attendance

You will be awarded a Certificate of Completion when you finish this course. You will be able to print or email the certificate and share your accomplishment with everyone.

How to Take Your Exam

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%

 

EXAM LOCATION

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

Ask the Instructure a Question

QA Forum

When you purchase this course you will be able to use the QA Forum and have direct access to the instructor.

Do you have special requirements?

    You need a free consultation, call us at those numbers:

    Mobile: +905419417882

    Mobile: +905551664551