BusinessObjects 6.5: Reporting: Level 2 (Advanced) UK Classes & Lessons (BusinessObjects)

About this class

If you are already an experienced user or have attended the Reporting with Business Objects courses, then this Advanced Reporting course is the next step. Delegates carry out activities throughout the course and reinforce learning after each section by performing practical exercises.

Who will the lesson benefit?

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

What delegates will learn

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.

What prerequisites are required

BusinessObjects : Reporting with BusinessObjects

Contents of this class

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.

Optional follow-on classes

BusinessObjects : Universe Appreciation Workshop
BusinessObjects : Universe Design