About this Course

BusinessObjects Web Intelligence is a query, reporting and analysis tool that allows you to access the data in your corporate databases directly from within BusinessObjects Enterprise  InfoView and to present and analyze this information in a Web Intelligence document. This one-day instructor-led classroom course is designed to give you the comprehensive skills needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. After completing this course, you will be able to create combined queries and use sub-queries. You will also be able to use character and date string functions, create variables using "If" logic, and redefine calculation contexts. The course also provides an optional appendix describing how to link Web Intelligence documents using the OpenDocument URL command.

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.

Course Outline

Lesson #1: Advanced Query Techniques

• Using combined queries
• Using sub-queries
• Creating a query based on another query
• Changing data sources
• Using the query drill
• Using query sampling
• Understanding dimensions and details

Lesson #2: Character and Date String Functions

• Using character string functions
• Concatenating different data types
• Using date functions

Lesson #3 Calculation Contexts

• Understanding calculation contexts
• Redefining calculation contexts

Lesson #4 Using IF Logic

• Grouping data with If() logic
• Modifying calculation behavior with If() logic
• Using IF/ELSEIF

Lesson #5 Additional Reporting Techniques

• Using data tracking
• Displaying data restricted by a filter or ranking
• Using additional report functions

Lesson #6 Linking to Documents

• Linking to documents and URLs in Web Intelligence
• Creating hyperlinks in the HTML Report Panel
• Creating hyperlinks in the Web Intelligence Rich Client and Java Report Panel