Contact Us
Company Name
Contact Person
Email Address or Phone
Detail

BOW320

Course Fee: HKD 10,000
Software Solution: Web Intelligence
Duration: 2 days
Level: Details, Configuration & Transaction

Goals

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"

Audience

  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User

Content

Web Intelligence Core Report Design

  • Reviewing Core Report Design Concepts

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

Advanced Query Techniques

  • Implementing Combined Queries
  • Implementing Subqueries
  • Creating a Query Based on Another Query
  • Changing Data Sources

Calculation Contexts

  • Describing Calculation Contexts
  • Redefining Calculation Contexts
  • Implementing Extended Syntax Operators
  • Implementing Extended Syntax Keywords
  • Defining Calculation Context

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

If Logic

  • Grouping Data
  • Executing the If() Function to Modify Calculation Behavior

Additional Reporting Techniques

  • Implementing Data Tracking
  • Implementing Additional Report Functions

Link Options in Web Intelligence Documents

  • Managing Links in Web Intelligence Documents
  • Using Element Linking to Filter Data

Managing Hyperlinks in the Web Intelligence Interactive Panel

Course Code: IVC/BOW320
Course Fee: HKD 10,000
Time: 2 days
Locoation: Lai Chi Kok
Apply Now: IVC/BOW320


Enquiry