BusinessObjects 6.5: Reporting: Level 2 (Advanced)

Show more BusinessObjects Training Courses

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

BusinessObjects 6.5: Reporting: Level 2 (Advanced) / BO302

(C) AquinasTraining.co.uk - Contact Us