Golden Consulting

BOW220 - BusinessObjects Web Intelligence XI R1/R2:
Advanced Report Design (formerly QA320R2)

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: Alternative 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 free-standing 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

Delivery & Duration

This instructor-led offering is a 1-day course.

Applicable Certifications

N/A


Outline Location: http://www.goldencg.com/edu/outlines/qa320r2.html

Golden Consulting Group, LLC
800 Cottage Grove Road
Building 3
Bloomfield, CT 06002

Telephone:      860.242.7704
Fax:                 860.242.7866
Email:              golden@goldencg.com     



Golden Consulting Group LLC © 2008 All Rights Reserved