WebIntelligence 4.2 Advanced Reporting

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:  formulas, variables and functions, multiple data providers, advanced query filters, subqueries, drilling on reports, cross tables and charts, combination queries, and revising SQL.

 

Audience:

This course is designed for WebIntelligence users and/or anyone using WebIntelligence  Desktop Reporting.

 

Duration: 

1 Day

 

Course Objectives:

Upon completion of this course, the participant 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, and revise SQL in existing reports.

 

 

Course Topics:

Creating/Editing Formulas

  • Creating/Editing Variables
  • Converting Formulas to Variables
  • Utilize Functions in Calculations
  • Adding New Queries
  • Duplicating Queries
  • Deleting Queries
  • Merging Dimensions to Link Data Providers
  • Creating Single Report Blocks From Multiple Data Providers
  • Object To Object Filters
  • Creating Subqueries (Any/All)
  • Query within Query
  • Setting Drill Preferences
  • Hierarchies
  • Drilling
  • Using Scope of Analysis
  • Snapshots
  • Union Queries
  • Intersect Queries
  • Minus Queries
  • Viewing SQL
  • Editing SQL
  • Saving Changes
  • Resetting Changes
  • Sharing/Utilizing Report Elements

 

Prerequisites:

WebIntelligence 4.2 Intermediate Reporting (1 Day)