Skip to Scheduled Dates
Course Overview
Participants will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents.
Who Should Attend
Application Consultants, Business Analysts, Business Process Owner / Team Lead / Power Users
Course Objectives
Create complex Web Intelligence documents using advanced query and reporting techniques, including: Combined queries and sub-queries Character and date string functions Variables and calculation contexts Link documents using hyperlinks
Course Outline
1 - Web Intelligence Core Report Design
- Reviewing Core Report Design Concepts
- Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC)
2 - Multiple Data Sources
- Synchronizing Data from Multiple Data Sources
- Creating Multiple Queries in a Document
- Synchronizing Data with Merged Dimensions
- Interacting with Other Data Providers
3 - Advanced Query Techniques
- Implementing Combined Queries
- Implementing Subqueries
- Creating a Query Based on Another Query
- Changing Data Sources
4 - Calculation Contexts
- Describing Calculation Contexts
- Redefining Calculation Contexts
- Implementing Extended Syntax Operators
- Implementing Extended Syntax Keywords
- Defining Calculation Context
5 - Formulas with Character and Date String Functions
- Creating Formulas with Character and Date String Functions
- Implementing the Right() Function
- Implementing the Replace() Function
- Implementing the SubStr() Function
- Implementing the Pos() Function
- Concatenating Character Strings
- Implementing Date Functions
6 - If Logic
- Executing If() to Group Data
- Executing the If() Function to Modify Calculation Behavior
7 - Hyperlinks in Web Intelligence Documents
- Managing Hyperlinks in Web Intelligence Documents
- Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel
- Managing Hyperlinks in the Web Intelligence Interactive Panel
8 - Additional Reporting Techniques
- Implementing Data Tracking
- Implementing Additional Report Functions