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, cross tables and charts, combination queries, and advanced reporting techniques.
Audience:
This course is designed for WebIntelligence™ users.
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 Single Report Blocks From Multiple Data Providers |
| Creating/Editing Variables | Object To Object Filters |
| Converting Formulas to Variables | Creating Subqueries (Any/All) |
| Utilize Functions in Calculations | Query within Query |
| Reference Cells | Union Queries |
| Context | Intersect Queries |
| Adding New Queries | Minus Queries |
| Duplicating Queries | Viewing and Editing SQL |
| Deleting Queries | Resetting and Saving Changes |
| Merging Dimensions to Link Data Providers | Hiding Cells, Blocks and Sections |
| Add To Merge | Linking Elements |
| Reporting From Excel, Text Files Directly | Shared Elements |
| Reporting From SQL Directly | |
| Reporting from Webi documents |
Prerequisites:
WebIntelligence™ 4.3 Intermediate Reporting (1 Day)