Mitratech - Connecting People, Knowledge, Process

Connecting People, Knowledge, Process

TeamConnect Business Objects Designer

This course is designed to provide students with a better understanding of TeamConnect Universe classes and objects. It will provide a solid foundation on how to create and format reports in BusinessObjects, and how to tweak the Universe.

Course Name:
TeamConnect Business Objects Designer

Audience:
Business Objects Designer

Duration:
3 Days

Format:
50% Lecture, 50 % Lab

Type:
Instructor-led training

Who Should Attend:

Any individual who is responsible for creating BusinessObjects reports.

Skill Level:
Intermediate

Available Locations:
Private Location, Online Course Delivery, Client Location

Skills Obtained:
  • Create reports for data analysis;
  • Create and modify classes and objects in the Universe.
Prerequisites:
  • Previous System Administration training;
  • Structured Query Language.

Course Outline:

Day 1 - TeamConnect Universe and Simple Report

TeamConnect Universe:

  • Universe as the middle tier between the database and the report
  • Connect to the BusinessObjects repository, and open the Universe
  • Universe’s tables and joins are created as mirror of the TeamConnect tables and their relationships
  • TeamConnect tabular are organized in classes and sub-classes, and fields are the objects
  • Connect the Universe to the database
  • Simple Report:
  • Start using BusinessObjects
  • Choose the data source (TeamConnect Universe)
  • Choose objects
  • Set pre-defined conditions
  • Run a Query
  • Modify a Query
  • Save a Document

Day 2 - Complex report, and Formula, Local Variable and Functions

Complex Reports

  • Deal with more complex report using custom conditions
  • Create sub-queries, query using Union, Intersect, and Minus
  • Add more queries to the report and use multiple data source
  • Change data source and refresh reports
  • Add, replace, move and remove data from tables
  • Formulas and Local Variables:
  • Understand formulas and local variables
  • Advantages and disadvantages of using formulas and local variables
  • Create formulas and local variables
  • Group values
  • Organize formulas and local variables
  • Functions:
    • Available functions
    • Use functions

Day 3 - Displaying data in tables and charts

  • Formatting section, table, chart, cell, page
  • Add Objects
  • Add Graphics
  • Add OLE