BOR220 - Desktop Intelligence XI R2: Advanced Report Design

Description: Desktop Intelligence is an integrated query, reporting and analysis solution that allows

business users to access the data in their corporate databases directly from their desktop and

present and analyze this information in a Desktop Intelligence document.

This course is designed to give learners the comprehensive skills needed to apply advanced reporting techniques in the creation of Desktop Intelligence documents. After completing this course, learners will be able to apply alternative query techniques in the creation of advanced Desktop Intelligence documents and reports. Learners will also be able to apply character and date string functions, create user-defined objects, group data, and use calculation contexts to further develop their documents and reports.

BusinessObjects 6.x and BusinessObjects XI R2 Objectives: This course is designed to teach learners using the XI R2 version how to apply advanced reporting techniques in the creation of documents using Desktop Intelligence. Note that there is not an XI R1 version of Desktop Intelligence and that the previous version is BusinessObjects 6.x full client. New features covered in this course include WebConnect is no longer available as a data source for reporting.

Student Profile: This course is designed primarily for business users who are experienced Desktop Intelligence report builders and who need to create advanced documents and reports. This course applies to BusinessObjects XI R1, XI R2, v6.5, 6.x, 5.x.

Prerequisites: None.

Curriculum: Course topics include:

Understanding Alternative Query Techniques

Define combined query types
Use combined queries
Use sub-queries
Create a query on a query

Using Character & Date String Functions

Understand character strings
Use the Replace function
Use the Right function
Use the SubString() function
Use the Pos() function
Concatenate different data types
Use Date functions

Create User-Defined Objects

Create user objects
Use a user object in a query
Edit a user object
Delete a user object
Store a user object

Grouping Data

Group data using If-Then-Else
Use If-Then-Else to modify calculations

Understanding Calculation Contexts

Understand Calculation Contexts
Use Forced Output Calculation Context
Use Forced Input Calculation Context
Identify Input & Output Context

Using Advanced Charting

Use charts
Invoke a secondary Y-axis
Apply multiple styles on a single Y-axis

Reporting From Other Data Sources

Use XML as a data source