Description

The client/server rendering module, called user module, has been replaced by Desktop Intelligence in version XI of SAP BusinessObjects®. This training will allow you to understand its concepts and master its querying and analysis functions in order to effectively manage your activities.

Who is this training for ?

For whom ?

End user, responsible for writing reports, all stakeholders involved in managing the business with SAP BusinessObjects®.

Prerequisites

Training objectives

Define the connection to the data to be returned Query universe data with queries Finely analyze data with crosstabs and charts Manage the display of data using filters, sorting and rankings Create calculation formulas and local variables to enrich reports

Training program

• Getting started with SAP BusinessObjects® Desktop Intelligence
  • Presentation of Desktop Intelligence, positioning in relation to the SAP BusinessObjects® range.
  • Report creation, access to data sources.
  • Choice of a universe .
  • The query editor.
  • The "Document" window: management of reports in the document.
  • The data manager, source content of a report.
  • Inserting a table into a report.
  • Managing cell content.
  • Refreshing universe data.
  • Practical work Getting started with the environment.
  • Creating a table from a basic query.
  • Updating the query.
  • Registration.
• Refine query parameters
  • The query: object, operator, operand.
  • Application of conditions.
  • Creation of a query from an existing one.
  • Nested conditions (And, Or).
  • Selecting a value at runtime.
  • Practical work Create and modify analyzes based on specific conditions.
  • Added prompt filter, nested conditions.
• Data presentation
  • Crosstabs.
  • Inserting a graph.
  • Placement in the document.
  • Grouping data by section.
  • The master report / detail.
  • Calculation in a section.
  • The "Rotation" window.
  • The breaks on the data.
  • Sorting data.
  • Practical work From the Rotation window, place a section.
  • Add a calculation, a table crossword and a graph.
  • Format the sections.
• Filtering and highlighting data
  • Place a filter on a column of a report.
  • Manage filters in the document.
  • Use of rankings and alerts.
  • Practical work Create filters to restrict report data.
  • Create alerts and rankings.
• Calculation formulas and variables
  • Adding calculations in reports: the formula editor.
  • Creating a local variable.
  • Aggregation: Sum, CumulativeSum.
  • Management of characters (concatenation.
  • ), dates (CurrentDate.
  • ).
  • Logical functions (Isnumber.
  • ) and conditionals (If.
  • ).
  • Document functions and data providers.
  • Practical work Return data calculated using formulas and variables.
• Data analysis and complements
  • Multidimensional analysis, the Explorer tool.
  • Publication in the document repository.