In this course, students will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning 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

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

Audience

The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users.

Language

English

Prerequisites

The prerequisites for this course include designing web intelligence documents.

$1,734

Length: 2.0 days (16 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
16
Nov
Thursday
9:30 AM ET -
5:30 PM ET
Almost Full
5 seat(s) left
Schedule select
24
Jan
Wednesday
9:30 AM ET -
5:30 PM ET
Almost Full
5 seat(s) left
Schedule select
14
Mar
Thursday
9:30 AM ET -
5:30 PM ET
Almost Full
5 seat(s) left
Schedule select
24
Apr
Wednesday
9:30 AM ET -
5:30 PM ET
Almost Full
5 seat(s) left
Loading...