Description

You will learn to master the advanced features of SAP BusinessObjects® Web Intelligence XI to create complex formulas, queries and reports.

Who is this training for ?

For whom ?

Advanced users of SAP BusinessObjects® Web Intelligence, future Universe Designer.

Prerequisites

Training objectives

Create advanced calculation formulas Perform complex queries and use contexts Assemble multiple data sources into a report by synchronizing data from different universes Create reports for the web

Training program

• Reminders on SAP BusinessObjects®
  • Choice of the universe.
  • The query editor.
  • Classes, objects.
  • Indicators or measures.
  • The dimensions or axes of analysis.
  • The information.
  • The conditions.
  • Report management.
• Creating formulas
  • Creating calculation formulas based on functions.
  • String-type functions.
  • Boolean-type functions.
  • Functions of numeric type.
  • Date-type functions.
  • Conditional operations in formulas.
  • Creating and using variables.
  • Jobs practices Creation of calculation formulas.
  • Using the different types.
• Creating queries
  • Creating complex queries.
  • Combination of queries.
  • Creating subqueries.
  • Ordering queries.
  • Mastery of operators and calculation contexts.
  • Use of contexts: Report, Block, Section, Break, Body.
  • Operators: In, ForAll and ForEach.
  • Practical work Creating complex queries.
  • Detailed use of operators.
• Report designs
  • Designing multi-block reports.
  • Designing multi-source reports.
  • Managing blocks and cells.
  • Synchronizing data from different universes.
  • Synchronization case study.
  • Assembly of multiple data sources in the same block.
  • Reports for the Web.