SAP Career Path Courses:

WebIntelligence™ 4.x Basic Reporting, the first course of a 3-course series, discusses the basic concepts of producing reports.  You will get an overview of the InfoView Portal as well as learn about creating queries and query filters.   We will teach you how to format reports and utilize the SpeedMenu.  You will learn about reporting functions, including ranking, breaking, foldline, sorting, local filtering and simple calculations.  We will also discuss conditional formatting, including cell format, text and variable alerters.  There will be lab exercises throughout the course to help you practice what you’ve learned, and require an in-house server running SAP BusinessObjects. Lab exercises are also demonstrated throughout the entire course.

View all course details Enroll Now
Video Title
Length
00: WebIntelligence™ 4.x Basic Reporting - Course Introduction
4 min
01: WebIntelligence™ 4.x Overview
28 min
WebIntelligence™ 4.x Overview Module Quiz 1
WebIntelligence™ 4.x Overview Module Quiz 2
02: Overview Quiz
10 min
03: The InfoView Portal
18 min
04: Building the Query
23 min
05: Adding the Query Filters
18 min
06: Complex Filters
22 min
07: Saving Documents
5 min
08: Exercise Demo: Building a Query
18 min
09: Using the Speed Menu
20 min
10: Formatting the Report
18 min
11: Advanced Formatting
5 min
12: Exercise Demo: Formatting the Report
15 min
13: Ranking and Breaking
22 min
14: Outlining and Sorting
14 min
15: Functions
15 min
16: Exercise Demo: Using Reporting Functions
19 min
17: Cell Formatting
22 min
18: Text and Variable Rules
14 min
19: Exercise Demo: Conditional Formatting
15 min
SAP BusinessObjects Web Intelligence 4.0 Certification Exam Sample Questions
Course Survey
View all course details

Module 00: WebIntelligence™ 4.x Basic Reporting - Course Introduction

Module 01: WebIntelligence™ 4.x Overview

  • WebIntelligence™ As a Tool
  • What Is WebIntelligence™?
  • WebIntelligence™/Desktop Reporting Differences
  • What Is a Universe?
  • WebIntelligence™ Users
  • Getting Started With WebIntelligence™
  • What Are Objects?
  • Introduction to Blocks

Module 02: Overview Quiz

Module 03: The InfoView Portal

  • Logging In
  • Viewing/Copying Folders
  • Copying Document and Hyperlinks
  • Customizing BI Workspaces
  • Demos

Module 04: Building the Query

  • What Is a Query?
  • Adding Objects
  • Adding the Query
  • Demos

Module 05: Adding the Query Filters

  • Adding Filters
  • Predefined Filters
  • Simple Filters
  • Demos

Module 06: Complex Filters

  • Building Complex Filters
  • Static Filtering
  • Dynamic Filtering
  • Demos throughout

Module 07: Saving Documents 

  • Saving Documents To Favorites
  • Saving Documents To Local File Formats
  • Printing Documents
  • Exercise: Building A Query
  • Demos throughout

Module 08: Exercise Demo: Building a Query

Module 09: Using the Speed Menu

  • Inserting, Duplicating, Deleting, Renaming Reports
  • Using New Copy/Paste Functionality
  • Inserting / Removing / Moving Columns
  • Demos

Module 10: Formatting the Report

  • Adding New Columns and Rows
  • Sizing Rows and Columns
  • Fonts, Colors, Etc
  • Hiding Objects
  • Justification
  • Demos throughout

Module 11: Advanced Formatting

  • Aligning Blocks
  • Alternating Row Colors
  • Unit of Measure
  • Exercise: Formatting the Report
  • Demos throughout

Module 12: Exercise Demo: Formatting the Report

Module 13: Ranking and Breaking

  • Ranking
  • Breaking
  • Properties
  • Demos

Module 14: Outlining and Sorting

  • Outlining
  • Sorting
  • Custom Sorting
  • Demos throughout

Module 15: Functions

  • Filtering
  • Calculations
  • Safe Order to Apply
  • Exercise: Using Reporting Function
  • Demos

Module 16: Exercise Demo: Using Reporting Functions

Module 17: Cell Formatting

  • What is Conditional Formatting
  • Creating Rules
  • Creating Conditions
  • Applying Conditional Formatting  to Reports
  • Demos

Module 18: Text and Variable Rules

  • Text Rules
  • Format Rules
  • Guidelines
  • Exercise: Conditional Formatting
  • Demos

Module 19: Exercise Demo: Conditional Formatting

View all course details

Basic Windows skills

View all course details

WebIntelligence 4.x Intermediate Reporting, the second course in a 3-part series, discusses the 4 major types of report blocks.  You will learn how to convert report blocks utilizing features like templates and TURN TO. We’ll discuss how to apply those same concepts to create charts.  You’ll create complex query filter prompts and learn how to mix AND/OR conditions together in a query filter.  You’ll work with more complex cross table reports and applying the various report functions in a cross tables.  You’ll learn how to create input controls in a report/chart to do dynamic filtering, and how to apply more advance conditional formatting features to a cross table report. There will be lab exercises throughout the course to help you practice what you’ve learned, and require an in-house server running SAP BusinessObjects. Lab exercises are also demonstrated throughout the entire course.

View all course details Enroll Now
Video Title
Length
00: WebIntelligence™ 4.x Intermediate Reporting - Course Introduction
5 min
01: Report Block Types
18 min
02: Creating Section Reports
24 min
03: Exercise Demo: Creating Types of Report Blocks
16 min
04: Creating Charts Part 1
24 min
05: Creating Charts Part 2
14 min
06: Creating Charts Part 3
15 min
07: Exercise Demo: Creating Charts
22 min
08: Creating Complex Query Filters
24 min
09: Using Ands and Ors
13 min
10: Exercise Demo: Creating Complex Conditions
19 min
11: Intermediate Cross Tables Part 1
17 min
12: Intermediate Cross Tables Part 2
15 min
13: Exercise Demo: Creating and Formatting Cross Tables
17 min
14: Advanced Cross Tables Part 1
18 min
15: Advanced Cross Tables Part 2
6 min
16: Input Controls
19 min
17: Exercise Demo: Advanced Cross Tables
16 min
18: Conditional Formatting Part 1
23 min
19: Conditional Formatting Part 2
13 min
20: Exercise Demo: Conditional Formatting
17 min
SAP BusinessObjects Web Intelligence 4.0 Certification Exam Sample Questions
Course Survey
View all course details

Module 00: WebIntelligence™ 4.x Intermediate Reporting - Course Introduction

Module 01: Report Block Types

  • Drag and Drop
  • Using Turn Into
  • Using Templates
  • Demos

Module 02: Creating Section Reports

  • Relative Positioning
  • Sectioning a Report
  • Formatting the Section
  • Exercise: Creating Types of Report Blocks
  • Demos

Module 03: Exercise Demo: Creating Types of Report Blocks

Module 04: Creating Charts Part 1

  • Using Templates
  • Using Turn To
  • Formatting Charts
  • Demos

Module 05: Creating Charts Part 2

  • Using New Chart styles
  • Color Formatting
  • Measure Values Orientation
  • Exercise: Creating Charts
  • Demos throughout

Module 06: Creating Charts Part 3

  • Changing Chart Style
  • Chart Dimensions
  • Changing Chart Variables
  • Exercise: Creating Charts
  • Demos throughout

Module 07: Exercise Demo: Creating Charts

Module 08: Creating Complex Query Filters

  • Creating Prompts
  • Prompt Properties
  • Cascading List of Values
  • Demos

Module 09: Using Ands and Ors

  • Creating Multiple Filters
  • Using Brackets
  • Mixing Ands and Ors
  • Exercise:  Creating Complex Conditions
  • Demos throughout

Module 10: Exercise Demo: Creating Complex Conditions

Module 11: Intermediate Cross Tables Part 1

  • Drag and Drop
  • Turn Into
  • Pivoting Via Headers
  • Demos

Module 12: Intermediate Cross Tables Part 2

  • Displaying Row and Column Headers
  • Crosstab formatting
  • Displaying Multiple Objects in the Headers
  • Exercise:  Creating and Formatting Cross tables
  • Demos throughout

Module 13: Exercise Demo: Creating and Formatting Cross Tables

Module 14: Advanced Cross Tables Part 1

  • Advanced Breaking: 
  • Break Properties
  • Advanced Ranking
  • Rank Properties
  • Demos

Module 15: Advanced Cross Tables Part 2

  • Sorting/Custom Sorting
  • Sorting on Properties
  • Filtering on Headings
  • Demos

Module 16: Input Controls

  • Creating an Input Control
  • Single Value/Multiple Value
  • Dimensions vs. Measures
  • Exercise: Advanced Cross Tables
  • Demos

Module 17: Exercise Demo: Advanced Cross Tables

Module 18: Conditional Formatting Part 1

  • Creating Rules
  • Cell Format
  • Text Format
  • Demos

Module 19: Conditional Formatting Part 2 

  • Variable Format
  • Applying Condtional Formatting to Cross table  
  • Editing and Reformatting Conditional Formatting
  • Exercise: Conditional Formatting
  • Demos

Module 20: Exercise Demo: Conditional Formatting

 

View all course details

WebIntelligence™ 4.x Basic Reporting

View all course details

WebIntelligence™ 4.x Advanced Reporting, the third course in a 3-part series, teaches you about formulas, variables and functions, multiple data providers, advanced query filters, subqueries, drilling on reports, cross tables and charts, combination queries, and and many of the new reporting features of v4.0.  We 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.  You will learn how to create subqueries, and we’ll  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, and require an in-house server running SAP BusinessObjects. Lab exercises are also demonstrated throughout the entire course.

View all course details Enroll Now
Video Title
Length
00: WebIntelligence™ 4.x Advanced Reporting - Course Introduction
4 min
01: Creating Formulas and Variables
25 min
02: Function Categories
26 min
03: Exercise Demo: Creating Formulas and Variables in a Report
25 min
04: Adding Queries
23 min
05: Merging Dimensions
25 min
06: Exercise Demo: Creating Reports from Multiple Data Providers
27 min
07: Subqueries
17 min
08: Query Within Query
9 min
09: Exercise Demo: Advanced Query Filters
19 min
10: Drilling Part 1
22 min
11: Drilling Part 2
22 min
12: Exercise Demo: Report Drilling
10 min
13: Combination Queries
15 min
14: Exercise Demo: Combination Queries
8 min
15: Advanced Formatting
10 min
16: Linking Reports and Creating Web Services
4 min
17: Exercise Demo: Advanced Formatting
6 min
SAP BusinessObjects Web Intelligence 4.0 Certification Exam Sample Questions
Course Survey
View all course details

Module 00: WebIntelligence™ 4.x Advanced Reporting - Course Introduction

Module 01: Creating Formulas and Variables

  • Creating A Formulas
  • Creating Variables
  • Editing Variables
  • Demos

Module 02: Function Categories

  • Using Functions In Variables
  • Using the Online Help
  • Using Context Operators
  • Exercise:  Creating Formulas and Variables in a Report
  • Demos

Module 03: Exercise Demo: Creating Formulas and Variables in a Report

Module 04: Adding Queries

  • Adding New Queries
  • Duplicating Queries
  • Deleting Queries
  • Demos

Module 05: Merging Dimensions

  • Merging Dimensions to Link Data Providers
  • Creating Single Block Reports
  • Auto Merging
  • Exercise: Creating Reports from Multiple Data Providers
  • Demos

Module 06: Exercise Demo: Creating Reports from Multiple Data Providers

Module 07: Subqueries

  • Object To Object Filters
  • Subquery Any
  • Subquery All
  • Demos throughout

Module 08: Query Within Query

  • Filters Based on Previous Queries
  • Exercise:  Advanced Query Filters
  • Demos throughout

Module 09: Exercise Demo: Advanced Query Filters

Module 10: Drilling Part 1

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

Module 11: Drilling Part 2

  • Using Scope of Analysis
  • Snapshots
  • Drill Mode
  • Exercise: Report Drilling
  • Demos throughout

Module 12: Exercise Demo: Report Drilling

Module 13: Combination Queries

  • Intersect Queries
  • Minus Queries
  • Exercise: Combination Queries
  • Demos throughout

Module 14: Exercise Demo: Combination Queries

Module 15: Advanced Formatting

  • Hiding Objects
  • Conditionally Hiding blocks and Cells
  • Conditionally Hiding Sections
  • Demos

Module 16: Linking Reports and Creating Web Services

  • Linking Reports
  • Linking Charts
  • Creating and Publishing Web Services
  • Exercise: Advanced Formatting
  • Demos throughout

Module 17: Exercise Demo: Advanced Formatting

 

 

View all course details

WebIntelligence™ 4.x Basic Reporting and WebIntelligence™ 4.x Intermediate Reporting

View all course details

Get Started Learning

SAP Today!

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. 

 

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, or print a course completion certificate.

Certificate of Completion

When you complete this course you will receive a Course Completion Certificate Download Link so you can print and/or email your Certificate of Completion.

Sample of Certification of Completion

QA Forum

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