| |
|
|
| | BOW220 (QA320R2) SAP BusinessObjects Web Intelligence: Advanced Report Design
One day instructor-led
course
Course Description
Advanced Report Design is a classroom-based course where
participants learn use advanced querying and reporting techniques
to create Web Intelligence documents. The course includes
presentation of concepts, following demonstration of features,
facilitated discussions, practice activities, and reviews.
After completing this course, learners will be able to:
Create Web Intelligence documents using advanced query
techniques Apply character and date string functions
Create variables using If
.Then
.Else
logic
Apply advanced reporting techniques using breaks, custom
sorts and functions
Understand calculation context and how to redefine them
Course Audience
The target audience for this course is experienced Web
Intelligence report designers. Prerequisite
education
To be successfully, learners who attend this course
must have attended the following offerings:
BusinessObjects Web Intelligence XI R1/R2: Report Design
Prerequisite knowledge/experience
To be successful, learners who attend this course
must have working knowledge of:
Core concept and functionality of Web Intelligence
Course Outline
Lesson#1- Advanced Query Techniques
Use combined queries
Use sub-queries
Create a query based on another query
Lesson summary
Lesson#2 - Character and Date Sting Functions
Character strings
Using the Replace() function
Using the Right() function
Using the SubString() function
Using the Pos() function
Concatenation different character strings
Using date functions
Lesson summary
Lesson#3 - Using If Logic
Grouping data
Using the If() function to modify calculation behavior
Lesson Summary
Lesson#4 - Advanced Reporting Techniques
Formatting breaks
Creating custom sorts
Displaying document data in free-standing cells
Displaying data restricted by a filter or ranking
Lesson summary
Lesson#5 - Calculation Contexts
Understanding calculation contexts
Redefining calculation contexts
Lesson summary
|
