|
WebIntelligence XI R2 Intermediate Reporting |
|
|
| 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
|
|
