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.
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
Who Should Attend?
Application Consultants, Business Analysts, Business Process Owner / Team Lead / Power Users
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Agenda
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