Training

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.

• Reviewing knowledge gained from experience and training on Web Intelligence
• Preparing for learning advanced report design concepts

• Using combined queries
• Using sub-queries
• Creating a query based on another query
• Changing data sources
• Understanding the impactof the query drill on performance

• Understanding calculation contexts
• Redefining calculation contexts

• Using character string functions
• Using the Replace () function
• Using the Right() function
• Using the SubString() function
• Using the Pos() function
• Concatenating different character strings
• Using date functions

• Using If() to group data
• Using the If() function to modify calculation behavior

• Using data tracking
• Using additional report functions

• Understanding the options for creating hyperlinks in Web Intelligence
• Creating hyperlinks in the different Web Intelligence interfaces

To be successful, you must have attended the following offering or have the equivalent knowledge of:

• BusinessObjects Web Intelligence XI 3.0: Report Design

To be successful, you must have working knowledge of:

• Experience designing Web Intelligence reports