TP3577

Intermediate Web Intelligence 4.3 Reporting Training

This Intermediate Web Intelligence® 4.3 Reporting training teaches attendees how to create different block structures, forms, cross table reports, complex conditions, charts, advanced cross tables, and more.

Note: This Webi class may also be taught using version 4.2.
Course Details

Duration

1 day

Prerequisites

All attendees should have taken our Introduction to Web Intelligence Reporting course or have the equivalent knowledge.

Skills Gained

  • Create different block structures
  • Create a variety of charts
  • Create complex conditions with prompts
  • Create complex crosstabs
  • Apply formatting options
  • Apply reporting functions
  • Apply Input Controls
  • Apply conditional formatting to cross table blocks
Course Outline
  • Introduction
    • Reporting Options
    • Drag and Drop
    • Using Turn Into
    • Creating cross tables
    • Creating Forms
    • Creating and Formatting Cross Tables
    • Using Turn Into
    • Relative Positioning Blocks
    • Sectioned Reports
    • Section Formatting
  • Creating Charts
    • Using Templates
    • Turn Into Charts
    • Using Assign Data
    • Using Properties Tab
    • Formatting Charts
    • Using New Chart Styles
    • Color Formatting
    • Measure Values Orientation
    • Filtering On Dimensions
    • Changing Chart Variables
  • Creating Complex Conditions
    • Using Prompts/Saving as Variants
    • Setting Default Values For Prompts
    • Creating Filters Based On Cascading LOV
    • Creating Multiple Filters
    • Using Ands/Ors
    • Using Brackets
  • Crosstabs Basic Formatting
    • Reviewing Blocks styles
    • Creating Cross Tables
    • Drag and Drop
    • Turn Into
    • Using Assign Data
    • 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
  • Functions and Sectioned Reports
    • Advanced Breaking
    • Break and Formula
    • Break Properties
    • Advanced Ranking:
    • Ranked Variable with Break
    • Rank Properties
    • Sorting/Custom Sorting
    • Filtering on Headings
    • Report Filters Panel
    • Using Input Controls
    • Utilizing Object Functions
    • Outlining
    • Inserting Sections
    • Creating Summary Cells
    • Adding Summary Cells to Sections
    • Saving Report to Local File Formats
  • Conditional Formatting
    • What is Conditional Formatting
    • Creating Rules
    • Creating Conditions
    • Cell Format
    • Text Format
    • Variable Format
    • Applying Conditional Formatting to Cross table Body/Headers
    • Editing and Reformatting Conditional Formatting
    • Applying Different Types of Conditional Formats
  • Conclusion