About this Course

Participants will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents.

Audience Profile

The target audience for this course is report designers who are experienced Web Intelligence users and who need to create complex Web Intelligence documents.

At Course Completion

After completing this course, participants will be able to create combined queries and use sub-queries. They will also be able to use character and date string functions, create variables using “If” logic, and redefine calculation contexts. They will learn how to link Web Intelligence documents using the hyperlink functionality and also create their documents using various SAP data sources.

Prerequisites

Essential: Learners should have attended the following courses: SAP BusinessObjects Web Intelligence: Report Design

Recommended: Experience designing Web Intelligence reports

Course Outline

Review Web Intelligence report design concepts

Working with advanced query techniques

• Using Combined Queries
• Using Subqueries
• Creating a Query Based on Another Query
• Changing Data Sources

Working with calculation contexts

• Understanding Calculation Contexts
• Redefining Calculation Contexts

Creating formulas with character and date string functions

• Using Character Strings
• Using the Right() function
• Using the Replace() function
• Using the SubStr() function
• Using the Pos() function
• Concatenating Different Character Strings
• Using Date Functions

Using If logic

• Using If() to Group Data
• Using the If() Function to Modify Calculation Behavior

Working with additional reporting techniques

• Using Data Tracking
• Using Additional Report Functions

Creating hyperlinks

• Working with Hyperlinks in Interactive Analysis Documents
• Creating Hyperlinks in the Interactive Analysis Interactive Panel
• Creating Hyperlinks in Interactive Analysis Desktop and the Java Report Panel

Creating a document using other data sources

• Using the SAP Data Source Options
• Creating a Document using an Existing BEx Query
• Creating a Document using a Hierarchical Universe
• Creating a Document using an Analysis View