WebIntelligence 3.1 Advanced Reporting

    

Summary:
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, crosstabs and charts, combination queries, and revising SQL.

Duration:
1 Day/Lecture & Lab

Audience:
This course is designed for WebIntelligence users and/or anyone using Desktop Intelligence reporting.

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 Down/Up/By/Through
• Using Scope of Analysis
• Snapshots
• Union Queries
• Intersect Queries
• Minus Queries
• Viewing SQL
• Editing SQL
• Saving Changes
• Resetting Changes

Prerequisites:
Students should have taken the WebIntelligence 3.0/3.1 Intermediate Reporting course before attending.

Last Update: May 23, 2012