DURATION
1 Day
Course Description
Web IntelligenceTM is a query, reporting and analysis tool that allows report designers to access
the data in their corporate databases directly from within BusinessObjects EnterpriseTM
InfoViewTM and to present and analyze this information in a Web Intelligence document.
This 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 combine queries and use sub-queries. You will also be able to use
character and date string functions, create variables using "If" logic, redefine calculation contexts,
as well as use advanced reporting techniques such as formatting breaks and using custom sorts.
BusinessObjects XI R1 and BusinessObjects XI R2
This course is designed to teach you, using both versions of the XI release, how to apply
advanced reporting techniques in the creation of documents using Web Intelligence. New
features covered in this courses that are not applicable to BusinessObjects XI Release 1 include:
Combining queries using union, intersection and minus
Using sub-queries
Creating custom sorts
Overriding a report filter or ranking with the NoFilter() function
Course Audience
The target audience for this course is report designers who are experienced Web Intelligence
users and who need to create advanced Web Intelligence documents.
Course Topics
Lesson#1 - Advanced Query Techniques
Using combined queries
Using sub-queries
Creating a query based on another
query
Lesson#2 - Character and Date String
Functions
Using the character string functions
Concatenating different data types
Using date functions
Lesson#3 – Using If Logic
Grouping data using If() logic
Using If() to modify calculation
behavior
Lesson#4 - Advanced Reporting Features
Formatting breaks
Creating custom sorts
Displaying document data in freestanding
cells
Overriding filters and ranking
Lesson#5 – Calculation Contexts
Understanding calculation contexts
Redefining the calculation context
Prerequisite Education
BusinessObjects Web Intelligence XI R1/XI R2: Report Design
Prerequisite Knowledge/Experience
Experience building Web Intelligence reports
Additional Education
N/A
Programme scope, delivery arrangements and suitability are confirmed during enquiry.