fr
en
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.

Qui devrait suivre ce cours?
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
Prérequis

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

Informations practiques

Durée

2 Days

Langues

FR / NL

Prix

€ 1500 + 3% VAT

Emplacement

Classroom Course

Plannings

Guaranteed to run

Sessions néerlandophones
07 - 08/3/2024Réserver
06 - 07/6/2024Réserver
10 - 11/10/2024Réserver
05 - 06/12/2024Réserver
Sessions francophones
22 - 23/2/2024Réserver
23 - 24/5/2024Réserver
19 - 20/9/2024Réserver
21 - 22/11/2024Réserver

Partagez ce cours sur

Réservez votre formation

Entrez vos informations pour confirmer votre réservation.

    Vous pourriez aussi être intéressé par

    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…

    Test de pré-requis

    Passer le test

    Vous cherchez une solution sur mesure ?

    Lancez-vous dans l’entraînement personnel