SAP

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.

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

Basic Windows skills

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.

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

WebIntelligence™ 4.x Basic Reporting

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.

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

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

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.

GogoTraining's SAP BusinessObjects Web Intelligence Report Design series consists of two courses:  SAP BusinessObjects Web Intelligence: Report Design Level 1 and Report Design Level 2.

Release 4.2 is a major change and 75% of the material covered in this course is brand new.  In this course SAP BusinessObjects Web Intelligence Reporting Expert Michael Ward teaches you by immersing you in the details from start to finish.  This online training course series comes with lectures, demos and hands-on exercises.  By taking this course and engaging in all the hands-on activities you will bypass 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, you will receive a 50 page v4.2 SP3 User Guide.

Version 4.2 allows you to build more extensive and complex reports utilizing the many new features.  You will learn how to create visualizations utilizing just Web Intelligence, how to create documents with multiple data sources including Excel and FreeHand SQL, and how to update Excel data sources.

In the Report Design Level I course you will be introduced to the basic concepts of producing reports.  You will get an overview of the BI Launchpad Portal as well as learn about creating queries and query filters.   You will learn how to format reports, utilize the SpeedMenu, and understand reporting functions, including ranking, breaking, outlining, sorting, grouping, local filtering, simple calculations, and conditional formatting, including cell format, text and variable conditional formatting. 

From here we will move on to discuss the 4 major types of report blocks.  You will learn how to convert report blocks utilizing features like templates and Turn Into. We’ll discuss how to apply those same concepts to create charts and you will create complex query filter prompts and learn how to mix AND/OR conditions together in a query filter.  From here we jump into more complex cross table reports and look at how to apply the various report functions in a cross tables.  Next you will 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 are 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.

Module 00: SAP BusinessObjects Web Intelligence 4.2 Report Design Level 1 - Course Introduction 

Module 01: Web Intelligence 4.2 Overview

• Web Intelligence As a Tool
• What Is a Universe?
• Web Intelligence Users
• Getting Started With Web Intelligence
• What Are Objects?
• Introduction to Blocks

Module 02: The BI Launchpad Portal

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

Module 02a: The BI Launchpad Portal Demo

Module 03: Building the Query

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

Module 03a: Building the Query Demo

Module 04: Adding the Query Filters & Demo   

Module 05: Complex Filters   

• Building Complex Filters
• Static Filtering
• Dynamic Filtering

Module 05a: Complex Filters Demo

Module 06: Saving Documents   

• Saving Documents To Favorites
• Saving Documents To Local File Formats
• Printing Documents

Module 06a: Saving Documents Demo

Module 07: Building a Query Exercise

Module 08: Using the Speed Menu

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

Module 08a: Using the Speed Menu Demo

Module 09: Formatting the Report

• Sizing Rows and Columns
• Fonts, Colors, Etc
• Hiding Objects
• Justification
• Adding Comments

Module 09a: Formatting the Report Demo

Module 10: Advanced Formatting

• Aligning Blocks
• Alternating Row Colors
• Unit of Measure

Module 10a: Advanced Formatting Demo

Module 11: Formatting the Report Exercise

Module 12: Ranking and Breaking

• Ranking
• Breaking
• Properties

Module 12a: Ranking and Breaking Demo

Module 13: Outlining and Sorting

• Outlining
• Sorting
• Custom Sorting

Module 13a: Outlining and Sorting Demo

Module 14: Functions

• Grouping
• Filtering
• Calculations
• Safe Order to Apply

Module 14a: Functions Demo

Module 15: Using Reporting Functions Exercise

Module 16: Cell Formatting

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

Module 16a: Cell Formatting Demo

Module 17: Text and Variable Rules

• Text Rules
• Format Rules
• Guidelines

Module 17a: Text and Variable Rules Demo

Module 18: Conditional Formatting Exercise

Module 19:  New Features

• Creating and using Share Objects
• Creating and using Reference Cells

Module 19a: New Features Demo

Module 20: Report Block Types

• Drag and Drop
• Using Turn Into
• Using Templates

Module 20a: Report Block Types Demo

Module 21: Creating Section Reports

• Relative Positioning
• Sectioning a Report
• Formatting the Section

Module 21a: Creating Section Reports Demo

Module 22: Creating Types of Report Blocks Exercise

Module 23: Creating Charts Part 1

• Using Templates
• Using Turn Into
• Sizing Charts

Module 23a: Creating Charts Part 1 Demo

Module 24: Creating Charts Part 2

• Formatting Charts
• Changing Color Palette

Module 24a: Creating Charts Part 2 Demo

Module 25: Creating Charts Part 3

• Changing Chart Style
• Chart Dimensions
• Changing Chart Variables

Module 25a: Creating Charts Part 3 Demo

Module 26: Creating Charts Exercise

Module 27: Creating Complex Query Filters

• Creating Prompts
• Prompt Properties
• Cascading List of Values

Module 27a: Creating Complex Query Filters Demo

Module 28: Using Ands and Ors

• Creating Multiple Filters
• Using Brackets
• Mixing Ands and Ors

Module 28a: Using Ands and Ors Demo

Module 29: Creating Complex Conditions Exercise

Module 30: Intermediate Cross Tables Part 1

• Drag and Drop
• Turn Into
• Pivoting Via Headers

Module 30a: Intermediate Cross Tables Part 1 Demo

Module 31: Intermediate Cross Tables Part 2

• Displaying Row and Column Headers
• Crosstab Formatting
• Displaying Multiple Objects in the Headers

Module 31a: Intermediate Cross Tables Part 2 Demo

Module 32: Creating and Formatting Cross Tables Exercise

Module 33: Advanced Cross Tables Part 1

• Advanced Breaking
• Break Properties
• Advanced Ranking
• Rank Properties

Module 33a: Advanced Cross Tables Part 1 Demo

Module 34: Advanced Cross Tables Part 2

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

Module 34a: Advanced Cross Tables Part 2 Demo

Module 35: Input Controls

• Creating an Input Control
• Single Value/Multiple Value
• Grouping Input Controls

Module 35a: Input Controls Demo

Module 36: Advanced Cross Tables Exercise

Module 37: Conditional Formatting Part 1

• Creating Rules
• Cell Format
• Text Format

Module 37a: Conditional Formatting Part 1 Demo

Module 38: Conditional Formatting Part 2 

• Variable Format
• Applying Conditional Formatting to Cross table 
• Editing and Reformatting Conditional Formatting

Module 38a: Conditional Formatting Part 2 Demo

Module 39: Conditional Formatting Exercise

Basic Windows Skills

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.

GogoTraining's SAP BusinessObjects Web Intelligence Report Design series consists of two courses:  SAP BusinessObjects Web Intelligence: Report Design Level 1 and Report Design Level 2.

Release 4.2 is a major change and 75% of the material covered in this course is brand new.  In this course SAP BusinessObjects Web Intelligence Reporting Expert Michael Ward teaches you by immersing you in the details from start to finish.  This online training course series comes with lectures, demos and hands-on exercises.  By taking this course and engaging in all the hands-on activities you will bypass 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, you will receive a 50 page v4.2 SP3 User Guide.

Version 4.2 allows you to build more extensive and complex reports utilizing the many new features.  You will learn how to create visualizations utilizing just Web Intelligence, how to create documents with multiple data sources including Excel and FreeHand SQL, and how to update Excel data sources.

In the Report Design Level I course you will be introduced to the basic concepts of producing reports.  You will get an overview of the BI Launchpad Portal as well as learn about creating queries and query filters.   You will learn how to format reports, utilize the SpeedMenu, and understand reporting functions, including ranking, breaking, outlining, sorting, grouping, local filtering, simple calculations, and conditional formatting, including cell format, text and variable conditional formatting. 

From here we will move on to discuss the 4 major types of report blocks.  You will learn how to convert report blocks utilizing features like templates and Turn Into. We’ll discuss how to apply those same concepts to create charts and you will create complex query filter prompts and learn how to mix AND/OR conditions together in a query filter.  From here we jump into more complex cross table reports and look at how to apply the various report functions in a cross tables.  Next you will 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 are 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.

Module 00: SAP BusinessObjects Web Intelligence 4.2 Report Design Level 1 - Course Introduction 

Module 01: Web Intelligence 4.2 Overview

• Web Intelligence As a Tool
• What Is a Universe?
• Web Intelligence Users
• Getting Started With Web Intelligence
• What Are Objects?
• Introduction to Blocks

Module 02: The BI Launchpad Portal

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

Module 02a: The BI Launchpad Portal Demo

Module 03: Building the Query

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

Module 03a: Building the Query Demo

Module 04: Adding the Query Filters & Demo   

Module 05: Complex Filters   

• Building Complex Filters
• Static Filtering
• Dynamic Filtering

Module 05a: Complex Filters Demo

Module 06: Saving Documents   

• Saving Documents To Favorites
• Saving Documents To Local File Formats
• Printing Documents

Module 06a: Saving Documents Demo

Module 07: Building a Query Exercise

Module 08: Using the Speed Menu

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

Module 08a: Using the Speed Menu Demo

Module 09: Formatting the Report

• Sizing Rows and Columns
• Fonts, Colors, Etc
• Hiding Objects
• Justification
• Adding Comments

Module 09a: Formatting the Report Demo

Module 10: Advanced Formatting

• Aligning Blocks
• Alternating Row Colors
• Unit of Measure

Module 10a: Advanced Formatting Demo

Module 11: Formatting the Report Exercise

Module 12: Ranking and Breaking

• Ranking
• Breaking
• Properties

Module 12a: Ranking and Breaking Demo

Module 13: Outlining and Sorting

• Outlining
• Sorting
• Custom Sorting

Module 13a: Outlining and Sorting Demo

Module 14: Functions

• Grouping
• Filtering
• Calculations
• Safe Order to Apply

Module 14a: Functions Demo

Module 15: Using Reporting Functions Exercise

Module 16: Cell Formatting

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

Module 16a: Cell Formatting Demo

Module 17: Text and Variable Rules

• Text Rules
• Format Rules
• Guidelines

Module 17a: Text and Variable Rules Demo

Module 18: Conditional Formatting Exercise

Module 19:  New Features

• Creating and using Share Objects
• Creating and using Reference Cells

Module 19a: New Features Demo

Module 20: Report Block Types

• Drag and Drop
• Using Turn Into
• Using Templates

Module 20a: Report Block Types Demo

Module 21: Creating Section Reports

• Relative Positioning
• Sectioning a Report
• Formatting the Section

Module 21a: Creating Section Reports Demo

Module 22: Creating Types of Report Blocks Exercise

Module 23: Creating Charts Part 1

• Using Templates
• Using Turn Into
• Sizing Charts

Module 23a: Creating Charts Part 1 Demo

Module 24: Creating Charts Part 2

• Formatting Charts
• Changing Color Palette

Module 24a: Creating Charts Part 2 Demo

Module 25: Creating Charts Part 3

• Changing Chart Style
• Chart Dimensions
• Changing Chart Variables

Module 25a: Creating Charts Part 3 Demo

Module 26: Creating Charts Exercise

Module 27: Creating Complex Query Filters

• Creating Prompts
• Prompt Properties
• Cascading List of Values

Module 27a: Creating Complex Query Filters Demo

Module 28: Using Ands and Ors

• Creating Multiple Filters
• Using Brackets
• Mixing Ands and Ors

Module 28a: Using Ands and Ors Demo

Module 29: Creating Complex Conditions Exercise

Module 30: Intermediate Cross Tables Part 1

• Drag and Drop
• Turn Into
• Pivoting Via Headers

Module 30a: Intermediate Cross Tables Part 1 Demo

Module 31: Intermediate Cross Tables Part 2

• Displaying Row and Column Headers
• Crosstab Formatting
• Displaying Multiple Objects in the Headers

Module 31a: Intermediate Cross Tables Part 2 Demo

Module 32: Creating and Formatting Cross Tables Exercise

Module 33: Advanced Cross Tables Part 1

• Advanced Breaking
• Break Properties
• Advanced Ranking
• Rank Properties

Module 33a: Advanced Cross Tables Part 1 Demo

Module 34: Advanced Cross Tables Part 2

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

Module 34a: Advanced Cross Tables Part 2 Demo

Module 35: Input Controls

• Creating an Input Control
• Single Value/Multiple Value
• Grouping Input Controls

Module 35a: Input Controls Demo

Module 36: Advanced Cross Tables Exercise

Module 37: Conditional Formatting Part 1

• Creating Rules
• Cell Format
• Text Format

Module 37a: Conditional Formatting Part 1 Demo

Module 38: Conditional Formatting Part 2 

• Variable Format
• Applying Conditional Formatting to Cross table 
• Editing and Reformatting Conditional Formatting

Module 38a: Conditional Formatting Part 2 Demo

Module 39: Conditional Formatting Exercise

Basic Windows Skills