Desktop Intelligence Advanced Report Design

After completing this course, delegates will be able to apply alternative query techniques in the creation of advanced Desktop Intelligence documents and reports. Delegates 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. 

This course is suitable for delegates who use either SAP BusinessObjects versions 6.x, XI R2, 3.0 and 3.1.

Who should attend?

This course is designed for business users who are experienced Desktop Intelligence report builders and who need to create advanced Desktop Intelligence documents and reports.

Delegates will be able to

• Apply alternative query and reporting techniques when creating advanced Desktop Intelligence documents.
• Create combined queries and use sub-queries.
• Use character and date string functions, create variables using "if" logic, redefine calculation contexts and create hyperlinks in your documents using Web Intelligence dialogue boxes.

Prerequisites

Delegates must have attended the following courses,

• SAP BusinessObjects - Desktop Intelligence Report Design or Desktop Intelligence FastTrack

Additional education

If you want to increase your skill level and knowledge, the following courses are recommended,

• SAP BusinessObjects - Universe Appreciation Workshop
• SAP BusinessObjects - Universe Design

Topics covered

Alternative Query Techniques

• Defining Combined Query Types
• Using Combined Queries
• Using Sub-Queries
• Creating a Query on a Query

Character and Date String Functions

• Understanding Character Strings
• Using the Replace Function
• Using the Right Function
• Using the SubString() Function
• Using the Pos() Function
• Concatenating Different Data Types
• Using Date Functions

User-Defined Objects

• Creating User Objects
• Using a User Object in a Query
• Editing a User Object
• Deleting a User Object
• Storing a User Object

Grouping Data

• Grouping Data Using "If… Then… Else…"
• Using If…Then…Else to Modify Calculations

Calculation Contexts

• Understanding Calculation Contexts
• Using Forced Output Calculation Context
• Using Forced Input Calculation Context
• Identifying Input and Output Context

Advanced Charting

• Using Charts
• Invoking a Secondary Y-axis
• Applying Multiple Styles on a Single Y-axis

Reporting from Other Data Sources

• Using XML as a data source