Intelligent Business Solutions

Training

Courses

Schedule

Enroll

Contact Us

Course Description

Web Intelligence XI R2:
Advanced Report Design

Description:  Web Intelligence is a query, reporting and analysis tool that allows report designers to access the data in their corporate databases directly from within BusinessObjects Enterprise InfoView and to present and analyze this information in a Web Intelligence document.

This course is designed to give learners the comprehensive skills needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. After completing this course, learners will be able to combine queries and use sub-queries. Learners 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 6.x and BusinessObjects XI R2 Objectives:  This course is designed to teach learners 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 learners include:

  • Combining queries using union, intersection and minus
  • Using sub-queries
  • Creating custom sorts
  • Overriding a report filter or ranking with the NoFilter() function

Abstract:  Web Intelligence is a query, reporting and analysis tool that allows report designers to access the data in their corporate databases directly from within BusinessObjects Enterprise InfoView and to present and analyze this information in a Web Intelligence document.

This course is designed to give learners the comprehensive skills needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. After completing this course, learners will be able to combine queries and use sub-queries. Learners 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.

Student Profile:  The target audience for this course is report designers who are experienced Web Intelligence users and who need to create advanced Web Intelligence documents. This course applies to BusinessObjects XI R1 and XI R2.

Prerequisites:  BusinessObjects Web Intelligence XI R1/XI R2: Report Design and experience building Web Intelligence reports.

Duration:  1 day

Curriculum:  Course topics include:

Understanding Alternative Query Techniques

  • Use combined queries
  • Use sub-queries
  • Create a query based on another query

Using Character & Date String Functions

  • Use the character string functions
  • Concatenate different data types
  • Use date functions

Using If Logic

  • Group data using If() logic
  • Use If() to modify calculation behavior

Understanding Advanced Reporting Features

  • Format breaks
  • Create custom sorts
  • Display document data in free-standing cells
  • Override filters & ranking

Using Calculation Contexts

  • Understand calculation contexts
  • Redefine the calculation context

 


Copyright © 2002-2008, Quorum Business Solutions, Inc. All rights reserved.