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

Prerequisites

Essential

  • BOW310SAP BusinessObjects Web Intelligence: Report Design

Recommended

  • None

Course based on software release

  • SBOP BI Platform 4.2

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