Business Objects 6.5 Advanced Reporting Course

Course Code: BO 26
Course Abstract: This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach BusinessObjects 6.5 advanced reporting concepts. Topics to be covered include advanced query features, sub-queries, combination queries, advanced conditions, hierarchies, variables, formulas, outlining, managing filters, inserting special fields, and conditional reporting.

Free BusinessObjects User Group Meeting available when you schedule this course.

 

Audience: This class is designed for both technical and non-technical business analysts working in a business environment who require access to information contained in a data warehouse to generate a variety of reports and graphs utilizing BusinessObjects advanced reporting tools.
Duration: 1 day
Learning Outcomes:

Upon completion of this course, the participant will be able to:
> Work with Conditions
> Create Complex Queries
> Work with Hierarchies
> Perform Advanced Drilling
> Work with Multiple Data Sources/Providers
> Export Data
> Share Reports
> Create Templates
> Work with Formulas and Variables
> Use Advanced Query Techniques
>Use New Reporting Tips and Techniques

Course Topics:

Business Objects Overview
Corporate Information Factory
Data Warehousing
Business Objects Data Sources/Providers
Objects Overview
Blocks Overview
Report Creation Overview
Query Building Overview
Block Creation Overview

Conditions
Creating
Removing
Condition Components (Object, Operator, Operand)
Single, Multiple, and Null Value Operators
Pattern Matching and Wildcards
Type a New Constant Operand
Show List of Values Operand
Prompts
Select an Object Operand
Multiple Conditions
(Using And, Or, and Shifting)

Advanced Query Features
Viewing/Using SQL
User Objects
Duplicating Data Providers

Combination Queries
Union Queries
Intersect Queries
Minus Queries

Subqueries
Create A Subquery (All) Operand
Create A Subquery (Any) Operand
Create A Subquery Operand
Calculation Operand
Using Query on Query Capability

Hierarchies and Advanced Drilling
Predefined Hierarchies
Creating Custom Hierarchies Scope of Analysis
Drill Through
Drill By
Drilling on Multiple Hierarchies
Drilling on Charts
Snapshots

Using Multiple Data Providers
Using Multiple Universes
Using Personal Data Files
Linking Data Providers
Using an XML Data Provider

Exporting Data
Local File Formats
DDE (Dynamic Data Exchange)
Creating and Applying Templates

Report Sharing
Sharing with Business Objects Users
Sharing with Non-Business Objects Users
Saving to Excel

Variables And Formulas
Creating Local Variables
Creating And Editing Formulas
Resetting Contexts

Tips & Techniques
Formula Examples
(ForEach, ForAll, In, If-Then-Else)
Outlining
Managing Filters
Inserting Special Fields
Conditional Reporting

Prerequisites: BusinessObjects 6.5 Basic Reporting BO 25
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning

Testimonials

“Great instructor – kept the class attentive and involved and kept it fun to learn. Allowed us to apply the knowledge to the context of our business.”

Student – Defining Requirements with Business Process Modeling & Use Cases