Find Courses Here
WebIntelligence XI R2 Intermediate Reporting Print E-mail
Course Length - 1 Day
 
Course Description

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach WebIntelligenceTM.  Topics include using templates, using Turn To, vertical, horizontal, forms and crosstab reports, master/detail, complex conditions, charts, complex conditions, advanced crosstabs, and drilling.

 
You Will Learn How To:

Upon completion of this course, the participant will be able to:

  • Create a variety of report format types
  • Create a variety of charts,
  • Create complex conditions
  • Create complex crosstabs
  • Apply reporting functions and alerters to crosstab blocks
 

Course Prerequisites

WebIntelligenceTM XI R2 Basic Reporting (1 Day).

 

Who Should Attend?

This course is designed for WebIntelligenceTM users and/or anyone using Desktop IntelligenceTM reporting.

 

Next Recommended Course

WebIntelligenceTM XI R2 Advanced Reporting (1 Day) .

 
Course Outline
Crosstabs, Forms and Charts
  • Using Templates
  • Creating Crosstabs
  • Creating Forms
  • Creating and Formatting Crosstabs
  • Creating and Formatting Charts
  • Creating Sectioned Reports
Creating Complex Conditions
  • Using Prompts
  • Setting Default Values For Prompts
  • Creating Filters Based On Cascading LOV
  • Creating Multiple Filters
  • Using Ands/Ors  
  • Using Brackets
Crosstabs Basic Formatting
  • Introduction to Blocks
  • Creating Crosstabs
  • Drag and Drop
  • Using Templates
  • Turn To
  • Pivoting Via Headers
  • Pivoting Via Structure Mode
  • Displaying Row and Column Headers
  • Removing/Replacing Headers
  • Displaying Multiple Objects in Headers
  • Effect of Adding Objects to the Query
  • Inserting/Removing Objects in Body of Block
  • Properties Tab
Functions and Master/Detail
  • Breaking:  Down/Across
  • Break and Formula
  • Break Properties
  • Ranking:  Down/Across
  • Ranked Variable with Break
  • Rank Properties
  • Sorting/Custom Sorting
  • Filtering on Headings
  • Report Filters Panel
  • Running Sum
  • If-Then-Else
  • Inserting Master Cells
  • Creating Summary Cells
  • Creating Master/Detail Report
  • Adding Summary Cells to Master
  • Saving Report to Excel
Alerters and Drilling and Charts
  • Cell Format Alerter
  • Text Format
  • Variable Format
  • Applying Alerters to Crosstab Body
  • Applying Alerters to Crosstab Headers
  • Editing and Reformatting Alerters
  • Applying Different Types of Alerters
  • Drilling on Crosstab Blocks
  • Hierarchies
  • Drill Mode
  • Single Dimension Drilling in Headings
  • Multiple Dimension Drilling in Crosstab Body
  • Drill Options Up, Down, Across
  • Converting to Chart