SAP BusinessObjects Web Intelligence 4.3: Report Design II Training in Switzerland

This course is also available in a self-paced e-learning format with an active subscription to the SAP Learning Hub, as BOW325.

This 2-day course is designed to give you the skills regarding advance Web Intelligence features through the fiorified BI Launchpad. You will learn how to create Web Intelligence documents for your reporting and analytical needs: to implement synchronized and combined queries, to force input and output calculation contexts with extended syntax operators, to implement formulas with character and date functions. You will also learn how to use Web Intelligence as a data model in other Web Intelligence document and SAP Analytics Cloud and, in addition, how to use element linking and copy link options in hyperlink.

• Essential

  • BOW310 SAP BusinessObjects Web Intelligence: Report Design I

• Recommended

  • None

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

This course will prepare you to:

• Create complex Web Intelligence documents using advanced query and reporting techniques, including:
• Merged Dimensions
• Combined queries and sub-queries
• Redefining Calculation Context
• Character and date string functions
• Variables and calculation contexts
• Group functions
• Pareto Analysis using functions
• Dynamic comparison in Geographical Charts
• Element Linking
• Link document components using hyperlinks

• Unit 1 Web Intelligence Core Report Design
  • Lesson 1: Reviewing Core Report Design Concepts

• Unit 2: Multiple Data Sources
  • Lesson 1: Synchronizing Data from Multiple Data Sources
  • Lesson 2: Creating Multiple Queries in a Document
  • Lesson 3: Synchronizing Data with Merged Dimensions
  • Lesson 4: Interacting with Excel
  • Lesson 5: Web Intelligence as a Data source

• Unit 3: Advanced Query Techniques
  • Lesson 1: Implementing Combined Queries
  • Lesson 2: Implement Subqueries
  • Lesson 3: Creating a Query Based on Another Query
  • Lesson 4: Changing Data Sources

• Unit 4: Calculation Contexts
  • Lesson 1: Describing Calculation Contexts
  • Lesson 2: Redefining Calculation Contexts
  • Lesson 3: Implementing Extended Syntax Operators
  • Lesson 4: Implementing Extended Syntax Keywords

• Unit 5: Formulas with Character and Date String Functions
  • Lesson 1: Creating Formulas with Character and Date String Functions
  • Lesson 2: Implementing the Right() Function
  • Lesson 3: Implementing the Replace() Function
  • Lesson 4: Implementing the SubStr() Function
  • Lesson 5: Implementing the Pos() Function
  • Lesson 6: Concatenating Character Strings
  • Lesson 7: Implementing Date Functions

• Unit 6: If Logic and Grouping Data
  • Lesson 1: Grouping Data
  • Lesson 2: Executing the If() Function to Modify Calculation Behavior

• Unit 7: Additional Reporting Techniques
  • Lesson 1: Implementing Additional Report Functions
  • Lesson 2: Performing a Pareto Analysis, Dynamic Comparison and Geographical Charts

• Unit 8: Link Options in Web Intelligence Documents
  • Lesson 1: Managing Links in Web Intelligence Document
  • Lesson 2: Element Linking
  • Lesson 3: Managing Hyperlinks in Web Intelligence and using OpenDocuments links