Description

This internship details the use of SAP BusinessObjects® Desktop Intelligence XI to learn how to design and develop rich and complex documents

Who is this training for ?

For whom ?

Advanced user, future world designer.

Prerequisites

Training objectives

Create advanced conditions on queries

Combine several queries

Improve the classification of data in the document with breaks or sections

Create advanced functions

Add conditional formatting on data

Restore data from multiple sources

Training program

• Advanced query conditions
  • Reminders about SAP BusinessObjects®: the universe, classes and objects.
  • The query editor.
  • Report management.
  • Creation of personal objects: dimensions or indicators.
  • Interactive queries: questions asked to the user.
  • Aggregation problems.
  • Advanced operators: Minus, Intersect, Union.
  • List of custom values.
  • Combination of queries.
  • Using subqueries.
  • Exploitation of user responses.
  • Practical work Exercise: manipulation to get back to grips with the tool and become familiar with the case studied.
  • Improving queries.
• Improved reporting structure
  • Set general filters.
  • Choose breaks or sections.
  • Management of placements and layout of blocks.
  • Management of the Header and Footer areas.
  • Management of page breaks.
  • Relative positioning: automate the layout.
  • Conflict between classifications, filters and sorts.
• Analysis and enhancement of data
  • Study of SAP BusinessObjects® functions.
  • Text manipulation.
  • Date management functions.
  • IS conditional functions.
  • Statistical functions and aggregate levels.
  • Variable contexts: For, In, Each.
  • Conditional display of constants, formulas and variables.
  • Conditional formatting.
  • Creating graphical indicators.
• Exploitation of multiple data sources
  • The different data sources.
  • Local data: Xls, Txt, Csv.
  • Gains and constraints of a multisource report.
  • Automatic linking of data sources.
  • Manual data synchronization.
  • Resolving complex synchronization cases.
  • Requalifying data.
  • Creating variables for synchronization.
  • Define and operate custom hierarchies.