• Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.


    Read More
  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

SAP BusinessObjects Web Intelligence 4.2 Training

Course duration

  • 2 days

Course Benefits

  • Understand BusinessObjects terminology and features
  • Build complete Web Intelligence reports
  • Restrict data using filters
  • Use various presentation styles
  • Analyze data
  • Use advanced query techniques
  • Use report functions
  • Create report variables
  • Use the If Then Else statement
  • Use calculation contexts
  • Report from multiple data sources
  • Share information with colleagues

Course Outline

  1. Introduction
    1. Training Objectives
    2. Overview of BusinessObjects Tools
    3. The eFashion Universe
    4. Course Book Overview
    5. Conventions Used In This Book
  2. The BI Launch Pad
    1. Starting the BI Launch Pad
    2. Setting Preferences
    3. Managing Documents
    4. Customizing the BI Launch Pad
    5. Searching for Reports
    6. Running Reports
  3. Creating Your First Report
    1. Accessing the eFashion Universe
    2. Accessing the Data Provider – Your Universe
    3. Data Area
    4. Result Objects
    5. Query Filters Area
    6. Data Preview Area
    7. Creating Your First Report
    8. Arranging Objects on the Page
    9. The Data Manager
    10. Questions for Discussion
  4. Selecting and Filtering Data
    1. Query Filters
    2. Creating a Simple Query Filter
    3. Creating Complex Query Filters
    4. Viewing Report SQL
    5. Query Properties
    6. Purging Report Data
    7. Creating User Prompts
    8. Report Filters
    9. Report Filters Toolbar
    10. Input Controls
    11. Matches Pattern
    12. Precedence – And/Or Conditions
    13. Questions for Discussion
  5. Evaluating Data
    1. Sorting
    2. Grouping
    3. Calculations
    4. Breaks
    5. Fold/Unfold In Outline Mode
    6. Ranking
    7. Question for Discussion
  6. Formatting Your Report
    1. Formatting Cells
    2. Special Fields
    3. Conditional Formatting Setting Alerts
    4. Fit To Page
    5. Working with Report Tabs
    6. Freezing Headers
  7. Working With Data
    1. Saving the Report in Different Formats
    2. Saving the Report in PDF Format
    3. Saving the Report in Excel Format
    4. Saving the Report in CSV Format
    5. Printing Your Report
    6. Questions for Discussion
  8. Charting
    1. Creating Charts
    2. Formatting Charts
    3. New Chart Formats
    4. Questions for Discussion
  9. Analyzing Data
    1. Multi-Dimensional Cross Tables
    2. Drill Through Analysis
    3. Scope of Analysis
  10. Functions and Variables
    1. Using Formulas
    2. Creating Variables Using If ( ) Functions
    3. Creating Complex Variables Using If Functions
    4. Working with Functions
    5. Aggregate Functions - Running Calculations
    6. Date Functions - Day Name
    7. Character Functions - Concatenation
    8. Report Variable - Average Revenue
    9. Hiding a Block With a Formula
    10. Grouping Variables
  11. Advanced Queries
    1. Creating Multiple Queries
    2. Merging Queries
    3. Using Sub-Queries
    4. Combined Queries
    5. Using Excel Data Providers
    6. Question for Discussion
  12. Viewing Your Reports
    1. Report Scheduling
    2. Sharing Reports
    3. Adding Static Documents
    4. Questions for Discussion

Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following would be useful for this Business Objects class:

  • No prior reporting experience is required.
  • Familiarity with Microsoft Office is helpful.
Since its founding in 1995, InterSource has been providing high quality and highly customized training solutions to clients worldwide. With over 500 course titles constantly updated and numerous course customization and creation possibilities, we have the capability to meet your I.T. training needs.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.