Course Length - 1 DayDescriptionThis 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 LearnUpon 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
PrerequisitesWebIntelligenceTM XI R2 Basic Reporting (1 Day). Who Should AttendThis course is designed for WebIntelligenceTM users and/or anyone using Desktop IntelligenceTM reporting. OutlineCrosstabs, 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
|