Desktop Intelligence XI R2 Advanced Reporting Course

Course Code: BO 56
Course Abstract:

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Desktop Intelligence XI R2 advanced concepts. Topics include; advanced query features, subqueries, combination queries, hierarchies and advanced drilling, tips and techniques.

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 the Desktop Intelligence Basic Reporting tools.

Duration: 1 day
Learning Outcomes:

Upon completion of this course, the participant will be able to:
> Create subqueries
> Create combination queries
> Create custom hierarchies
> Manage filters

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
Multiple Data Providers Overview
Variables and Formulas Overview

Advanced Query Features
View SQL
User Objects
Duplicating Data Providers

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

Combination Queries
Union Queries
Intersect Queries
Minus Queries

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

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

Prerequisites:

Desktop Intelligence XI R2 Basic and Intermediate

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