WebIntelligence™ Advanced Reporting

View Your Course Transcript

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning WebIntelligence™ Advanced Reporting Today!

Your Price: $495

Video Title	Minutes
00: Course Introduction	6
01: Creating Formulas and Variables	38
02: Utilizing Functions	39
03: Formulas, Variables and Functions Lab	36
04: Multiple Data Providers	38
05: Merging/Unmerging Dimensions	35
06: Multiple Data Providers/Merging Dimensions Lab	38
07: Advanced Query Filters	25
08: Advanced Query Filters Lab	22
09: Drilling	37
10: Using Scope of Analysis in Drilling	16
11: Drilling Lab	20
12: Combination Queries	19
13: Combination Queries Lab	17
14: Revising SQL	23
15: Course Summary & Evaluation	6
Total:	6 hours 55 minutes

Start Learning WebIntelligence™ Advanced Reporting Today!

Your Price: $495

Course Materials

Want to be able to access these helpful materials? Contact Us!

• Student Guide
• Exercise Guide
• Installation Guide
• Database File
• Biar File

Related Links

• Course Survey

For more information, contact us or call 1-877-546-4446

Start Learning WebIntelligence™ Advanced Reporting Today!

List Price: $995 Your Price: $495

Description

This WebIntelligence™ online training course covers advanced crosstabs, applying reporting functions and calculations to crosstabs, multiple data providers, advanced query filters, subqueries, drilling on reports and charts, combination queries, and revising SQL. WebIntelligence™ Advanced Reporting training is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach WebIntelligence™version 3.1.

In order to take this course you need to have taken WebIntelligence™ Basic Reporting and WebIntelligence™ Intermediate Reporting or have advanced experience in WebIntelligence™Reporting.

Objectives

As a result of taking this WebIntelligence™ 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

Related Training

• Course: WebIntelligence™ Basic Reporting
• Course: WebIntelligence™ Intermediate Reporting
• Podcast: What’s New In Business Objects 3.1
• Podcast: Using WebIntelligence 3.1 Rich Client
• Podcast: Accessing Multiple Data Providers In WebIntelligence 3.1
• Podcast; Using Formulas, Variables And Functions In WebIntelligence 3.1 Reporting

For more information, contact us or call 1-877-546-4446

Start Learning WebIntelligence™ Advanced Reporting Today!

List Price: $995 Your Price: $495

WebIntelligence™ Advanced Reporting Outline

Module 00: WebIntelligence™ Advanced Reporting Online Training - Course Introduction

Module 01: Creating Formulas and Variables

• Creating and Validating Formulas
• Converting Formulas to Variables
• Creating Variables
• Editing Variables
• Duplicating Variables
• Deleting Variables

Module 02: Utilizing Functions

• Function Categories
• Using Functions in Formulas
• Using Functions in Variables
• Context Operators

Module 03: Formulas, Variables and Functions Lab

Module 04: Multiple Data Providers

• Adding New Queries
• Duplicating Queries
• Deleting Queries

Module 05: Merging/Unmerging Dimensions

• Merging Dimension to Link Data From Multiple Data Providers
• Creating Single Report Blocks From Multiple Data Providers
• Unmerging Dimensions

Module 06: Multiple Data Providers/Merging Dimensions Lab

Module 07: Advanced Query Filters

• Object to Object Filters
• Creating Subqueries Any
• Creating Subqueries All

Module 08: Advanced Query Filters Lab

Module 9: Drilling

• Setting Drill Preferences
• Hierarchies
• Drilling Down/Up/By/Through
• Snapshots
• Drill Mode

Module 10: Using Scope of Analysis in Drilling

• Using Scope of Analysis
• Single Dimension Drilling in Headings
• Multiple Dimensions Drilling in Crosstabs
• Drilling on Charts

Module 11: Drilling Lab

Module 12: Combination Queries

• Union Queries
• Intersect Queries
• Minus Queries

Module 13: Combination Queries Lab

Module 14: Revising SQL

• Viewing SQL
• Editing SQL
• Saving SQL
• Resetting Changes in SQL

Module 15: WebIntelligence™ Advanced Reporting Online Training - Course Summary & Evaluation

 

For more information, contact us or call 1-877-546-4446

Start Learning WebIntelligence™ Advanced Reporting Today!

List Price: $995 Your Price: $495

Prerequisites

WebIntelligence™ Intermediate Reporting online training or equivalent experience

For more information, contact us or call 1-877-546-4446

Start Learning WebIntelligence™ Advanced Reporting Today!

List Price: $995 Your Price: $495

System Requirements

This course uses WebIntelligence XI, R2/3 and requires the download of specific files in order to do the labs.

For more information, contact us or call 1-877-546-4446

Start Learning WebIntelligence™ Advanced Reporting Today!

List Price: $995 Your Price: $495

When you purchase a course from GogoTraining, you can submit comments or questions to our expert instructors.