Back to Search Results

Training Course Summary:

Advanced Reporting with BusinessObjects

What skills will the delegate gain?
This course will enable delegates to:

Combine the results of more than one query, using Union, Intersection & Minus.
Use the results of one query as starting point for a second query.
Change the context in which calculations work.
Use the ‘If…. Then…. Else….’ Statement to streamline data extraction.
Use Group values to create derived variables.
Convert derived variables.
Create user objects to improve report functionality.
Apply advanced character and numeric functions.
Improve formatting within reports.
Use value-based breaks.
Apply conditional reporting to automate formatting.
Combine functions with conditional reporting functionality.

Pre-Requisites:

BusinessObjects : Reporting with BusinessObjects (BOP6) or BusinessObjects : FastTrack (BFT6) or equivalent business experience.

Who Should Attend:

The course is designed for Users who can already construct simple queries and calculations to answer business questions.

Training Course Overview/Content:

Query Techniques
Methods of Combining Queries.
Sub-queries.

Calculation Contexts
Calculation Contexts.
Contexts Reference.

If.. Then.. Else.. / Group by
Using ‘If.. Then.. Else..’.
Use the Group Function.
Convert Derived Variables.

User Objects
Creating User Object Calculations.
Applying Functions to Text.
Grouping Data.
Restrictions on User Objects.

Formatting
Block Layout.
Value-based Breaks.
Adding Standard Calculations.
Folding a Broken Report.
Calculations in Cross tabs.

Conditional Reporting
Conditional Reporting.