BusinessObjects 6.5: Reporting: Level 2 (Advanced)

Course Overview

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.

Audience

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

Skills Gained

• 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.

Prerequisites

BusinessObjects : Reporting with BusinessObjects

Course Outline

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.

Follow On Courses

• BusinessObjects : Universe Appreciation Workshop
• BusinessObjects : Universe Design