Webintelligence XI R2 Advanced Reporting Course

Course Code: BO 59
Course Abstract: This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach WebIntelligence. Topics include: 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.
Audience: This course is designed for WebIntelligence users and/or anyone using Desktop Intelligence reporting.
Duration: 1 day
Learning Outcomes:

Upon completion of this course, the participant will be able to:

> Create complex crosstab reports
> Build advanced queries
> Access multiple data providers
> Merge multiple data providers
> Create combination queries
> Create drillable reports
> Revise SQL in existing reports

Course Topics:

Variables and Functions
Creating And Validating Formulas
Creating Variables
Editing Variables
Duplicating Variables
Deleting Variables
Using Functions In Variables

Advanced Query Filters 
Object To Object Filters
Creating Subqueries (Any/All)

Multiple Data Providers
Adding New Queries
Duplicating Queries
Deleting Queries
Merging Dimensions to Link Data Providers
Creating Single Report Blocks From Multiple Data Providers

Combination Queries
Union Queries
Intersect Queries
Minus Queries

Drilling
Setting Drill Preferences
Hierarchies
Drilling Down/Up/By/Through
Using Scope of Analysis
Snapshots

Revising SQL  
Viewing SQL
Editing SQL
Saving Changes
Resetting Changes

Prerequisites: WebIntelligence XI R2 Intermediate course is required.
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning