Description
This training is aimed at users of SAP BusinessObjects® Web Intelligence XI 3.0. It will introduce them to using the query editor to select the data to analyze, as well as the various presentation and report enrichment functions, such as calculation formulas and different methods of grouping data.
Who is this training for ?
For whom ?End user, responsible for writing reports, any actor involved in managing the business with SAP BusinessObjects®.
Prerequisites
Training objectives
Training program
- InfoView and document management
- Connecting and disconnecting from InfoView.
- Remembering SAP BusinessObjects® vocabulary.
- Creating, editing, and saving Web Intelligence documents.
- Selecting the Web Intelligence document editor.
- Overview of the report editor interface.
- Creating, editing, and saving Web Intelligence documents.
- Query Editor Overview
- Presentation and management of interface elements (data, results, filter.
- ).
- Defining the properties of a simple query.
- Familiarization with data providers and universes.
- Functions linked to the result of the query (refresh, purge, export).
- Practical work Creation of a first Web Intelligence document with a simple condition query.
- Select query data
- How filters work, using predefined filters.
- Combinations of several filters in a query.
- Single condition and nested condition.
- Usable operators and operands.
- Database collation.
- Prompt filters.
- Custom filters.
- Practical work Handling simple, combined filters.
- Creating a query filter with prompt.
- Format tables
- Adding simple tables to a report.
- Table presentation templates.
- Formatting on a table.
- Crosstabs.
- Exercise: Creating and modifying various types of tables, simple and crosstabs.
- Highlight data
- Diagrams and diagram templates.
- Turn a table into a diagram.
- Creating, using, and formatting diagrams.
- Formatting Quick diagrams.
- The principle of alerters.
- Using the alerter formatting functions.
- Introduction to various types of alerters.
- Implementation of a ranking (or ranking).
- Exercise: Insertion and formatting of different types of diagrams.
- Creation of document with alerts and rankings.
- Highlighting relevant indicators.
- Group and filter data in a report
- Grouping data by section.
- Creating breaks on the data.
- Sorting on the data.
- Behavior of calculations in within a section.
- Tracking data.
- How report filters work.
- Filters at the block and report level.
- Applying multiple filters in a report.
- Modifying and deleting report filters.
- Exercise: Creating a document with a break.
- Manipulating sections to present data.
- Creating multiple block and report filters.
- Calculation formulas and variables
- Insertion of calculations in simple and cross tables (sum, counter, %).
- Insertion of calculated cells (page number, document name, update date, response to prompts, etc.
- ).
- Use the formula editor to create custom expressions.
- Calculations on numbers.
- Date manipulation formulas.
- Text manipulation formulas.
- Conditional formulas.
- Variables: creation, modification and deletion.
- Using variables to simplify formulas.
- Exercise: Creating various calculation formulas.
- Using conditional functions.
- Variable registration.
- Organization of documents and supplements
- Multidimensional analysis, understand the principle of exploration in hierarchies.
- Insertion of data from different queries, from different universes.
- Insertion of data from external providers (Web Intelligence Rich Client only).
- Principle of synchronizing data from different sources.
- Saving and managing WebI documents in InfoView (filter, explore, refresh, enter the parameters).
- Scheduling the execution and distribution of reports.
- Saving documents in Excel or PDF format.
- Exercise : Sharing documents.
- Exercise: synthesis.
