en
nlfr
IT Training

SAP BusinessObjects Web Intelligence 4.2: Report Design II (BOW 320)

This 2-day course is designed to give you the skills regarding advanced SAP Web Intelligence™ features. You will learn how to create Web Intelligence documents for your reporting needs: to implement a combined queries, to force input and output calculation contexts, to implement formulas with character functions and date functions. You’ll also learn how to filter dynamically using element linking.

Who should attend this course?
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
Prerequisites

It is essential to have attended BOW310 : SAP BusinessObjects Web Intelligence 4.2: Report Design I

This course will prepare you to:

  • 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

Web Intelligence Core Report Design

Reviewing Core Report Design

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

Formulas with Character and Date String Functions

  • Creating Formulas with Character and Date String
  • Implementing the Right() Function
  • Implementing the Replace() Function
  • Implementing the SubStr() Function
  • Implementing the Pos() Function
  • Concatenating Character Strings
  • Implementing Date Functions

If Logic and Grouping Data

  • 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
  • Managing Hyperlinks in the Web Intelligence

Managing Hyperlinks in the Web Intelligence Interactive Panel

Practical information

Duration

publish

Languages

FR / NL

Price

€ 1500 + 21% VAT

Location

Classroom Course

Schedule

Guaranteed to run

Sessions in English
Contact us for more infoBook
Sessions in Dutch
07 - 08/3/2024Book
06 - 07/6/2024Book
10 - 11/10/2024Book
05 - 06/12/2024Book
Sessions in French
22 - 23/2/2024Book
23 - 24/5/2024Book
19 - 20/9/2024Book
21 - 22/11/2024Book

Share this course on

Book your training

Enter your information to confirm your booking.

    You might also be interested in

    Database Management & Data AnalysisDatabase Management & Data Analysis
    PL-300: Microsoft Power BI Data Analyst
    21 - 23/2/2024, 19 - 21/6/20 ...
    This course covers the various methods and best practices that are in line with business and technical requirements for modeling,…
    Database Management & Data AnalysisDatabase Management & Data Analysis
    N° 55315 – Introduction to SQL Databases
    17 - 19/1/2024, 15 - 17/4/20 ...
    55315A is the equivalent of the retired legacy MOC Course 10985C – Introduction to SQL Databases. The 55315A three-day instructor-led…
    Database Management & Data AnalysisDatabase Management & Data Analysis
    Querying SQL Server with Transact-SQL
    05 - 07/2/2024, 18 - 20/3/20 ...
    The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for…
    Database Management & Data AnalysisDatabase Management & Data Analysis
    SQL Server Performance Tuning and Optimization
    26 - 29 Feb & 01 Mar, 22 - 2 ...
    This course is designed to give the right amount of Internals knowledge and wealth of practical tuning & optimization techniques…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training