Description

This internship will allow you to master the advanced features of SAP BusinessObjects® Web Intelligence 4 to create complex formulas, queries and reports. The numerous examples and practical cases will show you how to get the most out of this powerful tool.

Who is this training for ?

For whom ?

Advanced Web Intelligence users, future world designers.

Prerequisites

Training objectives

Manipulate query combinations to retrieve different data scopes Create queries based on multiple universes by synchronizing data Master complex calculation formulas Use the calculation context operators “In”, “For all”, “For each” wisely Perform exploratory analysis on data in SAP BusinessObjects® Web Intelligence

Training program

• Reminders
  • The universes in SAP BusinessObjects®.
  • The choice of the universe.
  • The query editor.
  • The classes, objects.
  • Reminders of principles and use.
  • Indicators, dimensions, information.
  • Conditions.
  • Report management.
  • Practical work Quick handling of the main functionalities in order to get your bearings.
• Creating advanced queries
  • Advanced possibilities in terms of queries.
  • Use of complex operators.
  • Combination of queries.
  • Creation of subqueries.
  • Practical work Creation of combinations of queries to retrieve different data scopes.
  • Use of subqueries.
• Query synchronization
  • Merging queries from several universes.
  • Synchronization of dimensions and indicators.
  • Creation of "Information" objects to synchronize all objects.
  • Using the "Force Merge" function.
  • Resolving synchronization-related errors.
  • Practical work Creating queries based on two universes and synchronization.
  • Synchronization between heterogeneous aggregation levels.
• Calculation formulas and contexts
  • The advanced possibilities of formulas.
  • Creating and using variables.
  • Using the "Relative value" function.
  • What is a "computation context"? The calculation context operators "In", "For all", "For each".
  • Using contexts to calculate percentages.
  • Using functions linked to filters.
  • Practical work Creating complex calculation formulas.
  • Using the different types of functions.
  • Using the operators "In", "For all" and "For each".
• Analyze data with SAP BusinessObjects® Web Intelligence
  • Using input controls and the filter bar.
  • Impacts of input controls and the filter bar in the structure pane of a document.
  • Setting up navigation by linking.
  • Data exploration.
  • Definition of the scope of analysis and importance of hierarchies.
  • Drilling forwards and backwards.
  • Reports for the Web.
  • Practical work Creating input controls on the database dimensions and indicators, setting up a data perimeter and using exploration.