business objects Training advanced reporter training course from PPA title

         business objects businessobjects business intelligence Training advanced reporter training course from PPA logo

PPA Home Page

More Courses

Next course:
Friday 21st May 2008

Location: Guildford, Surrey

Price: £299  vat including course notes, lunch and unlimited e-mail support.

Related training courses:

Business Objects Introductory Course

Contact us for details of availability or to book a place.

Run this course on your own premises from £750 (+vat) per day for up to 3 people. Add just £99 for additional delegates, plus the trainer's travelling and overnight accommodation costs if necessary. Larger group discounts available.

For details of courses in the Republic of Ireland visit www.ppatraining.ie

business objects businessobjects business intelligence Training advanced reporter training course from PPA duration title

This course is suitable for users wishing to learn how to create queries and build reports using "Full Client" versions of Business Objects up to version 6.5 and users of Desktop Intelligence version XI. It is not suitable for those who need to learn Web Intelligence versions of Business Objects. Please contact us for details of Web Intelligence training courses.

Business Objects is a reporting tool for SQL compliant databases. It allows users to prepare custom reports from a number of databases using a Business Objects Universe, which in turn facilitates advanced reporting and data analysis.

Advanced Reporters are identified as those Business Objects users within an organisation who have full access to the Business Objects Universes, and who need to build queries using advanced report-writing techniques for in-depth analysis of business information. Report Writers also create flexible reports for use by “Explorers” – Business Objects users who don’t have access to the universes and so are unable to build queries, but are able to open documents created by others and manipulate, analyse and present the data in a variety of ways.

Delegates attending this course will be assumed to be familiar with the contents of the Introductory Course, or to have completed other training that establishes similar competencies – such as the Business Objects online “Personal Trainer”  module.

During this Business Objects training course you will learn about:

business objects Training advanced reporter training course from PPA pre-course challenge title

  • Refresher Exercise on Basic Skills

  • Revision of Basic Skills as required

business objects businessobjects business intelligence Training advanced reporter training course from PPA editing reports title

  • Editing Blocks

  • Applying Filters

  • Formatting Filters

  • Applying Sorts

  • Formatting Sorts

business objects businessobjects business intelligence Training advanced reporter training course from PPA formatting reports title

  • Creating and Using Templates

  • Page Formatting Options

  • Formatting Tables

  • Formatting Sections

  • Adding Page Breaks

  • Formatting Charts

  • Aligning Cells

  • Aligning Blocks

business objects businessobjects business intelligence Training advanced reporter training course from PPA restricting with conditions title

  • Multi-Value Conditions

  • Using the Logical Operators (AND/OR)

  • Pre-Defined Conditions

  • Prompted Condition Queries

  • Using Wildcards in Queries

  • Displaying Prompt Criteria in Reports

  • Creating Subqueries

  • Combine Queries (Union, Intersect and Minus)

business objects businessobjects business intelligence Training advanced reporter training course from PPA multiple data providers title

  • Understanding the concept of a Data Provider

  • Multiple Queries (Data Providers) from a Single Universe

  • Naming Data Providers

  • Querying Multiple Universes in a Single Document

  • Using Personal Data Files (Eg. Microsoft Excel spreadsheets) as Data Sources

  • Synchronising Data Providers by Linking

  • Numeric Data Format Issues

business objects businessobjects business intelligence Training advanced reporter training course from PPA using variables title

  • Creating Variables

  • Resetting Calculations across Breaks

  • If..Then…Else Variables

  • The Group Function

  • Creating a Variable Using the Group Function

  • Understanding Calculation Contexts

business objects businessobjects business intelligence Training advanced reporter training course from PPA slice & dice title

  • The Slice and Dice View

  • Converting Tables to Crosstabs

  • Converting Table Blocks to Charts

  • Adding Breaks, Totals, Filters and other Functions

business objects businessobjects business intelligence Training advanced reporter training course from PPA drilling title

  • Understanding Hierarchies

  • Setting the Scope of Analysis

  • Pre-Defined Hierarchies

  • Drilling on Single Hierarchies

  • Drilling on Multiple Hierarchies

  • Creating Custom Hierarchies

  • Drilling on Charts

  • Displaying the Drill Information

  • Saving Snapshots

 business objects businessobjects business intelligence Training advanced reporter training course from PPA exporting title

  • Exporting Data from a Block

  • Exporting Data from a Data Provider