SAP BusinessObjects Web Intelligence 4.2 Report Design Level 1

Module 00: SAP BusinessObjects Web Intelligence 4.2 Report Design Level 1 – Course Introduction 

Module 01: Web Intelligence 4.2 Overview

• Web Intelligence As a Tool
• What Is a Universe?
• Web Intelligence Users
• Getting Started With Web Intelligence
• What Are Objects?
• Introduction to Blocks

Module 02: The BI Launchpad Portal

• Logging In
• Viewing/Copying Folders
• Copying Document and Hyperlinks
• Customizing BI Workspaces

Module 02a: The BI Launchpad Portal Demo

Module 03: Building the Query

• What Is a Query?
• Adding Objects
• Adding the Query

Module 03a: Building the Query Demo

Module 04: Adding the Query Filters & Demo   

Module 05: Complex Filters   

• Building Complex Filters
• Static Filtering
• Dynamic Filtering

Module 05a: Complex Filters Demo

Module 06: Saving Documents   

• Saving Documents To Favorites
• Saving Documents To Local File Formats
• Printing Documents

Module 06a: Saving Documents Demo

Module 07: Building a Query Exercise

Module 08: Using the Speed Menu

• Adding, Duplicating, Deleting, Renaming Reports
• Using New Copy/Paste Functionality
• Inserting/Removing/Moving Columns

Module 08a: Using the Speed Menu Demo

Module 09: Formatting the Report

• Sizing Rows and Columns
• Fonts, Colors, Etc
• Hiding Objects
• Justification
• Adding Comments

Module 09a: Formatting the Report Demo

Module 10: Advanced Formatting

• Aligning Blocks
• Alternating Row Colors
• Unit of Measure

Module 10a: Advanced Formatting Demo

Module 11: Formatting the Report Exercise

Module 12: Ranking and Breaking

• Ranking
• Breaking
• Properties

Module 12a: Ranking and Breaking Demo

Module 13: Outlining and Sorting

• Outlining
• Sorting
• Custom Sorting

Module 13a: Outlining and Sorting Demo

Module 14: Functions

• Grouping
• Filtering
• Calculations
• Safe Order to Apply

Module 14a: Functions Demo

Module 15: Using Reporting Functions Exercise

Module 16: Cell Formatting

• What is Conditional Formatting
• Creating Rules
• Creating Conditions
• Applying Conditional Formatting to Reports

Module 16a: Cell Formatting Demo

Module 17: Text and Variable Rules

• Text Rules
• Format Rules
• Guidelines

Module 17a: Text and Variable Rules Demo

Module 18: Conditional Formatting Exercise

Module 19:  New Features

• Creating and using Share Objects
• Creating and using Reference Cells

Module 19a: New Features Demo

Module 20: Report Block Types

• Drag and Drop
• Using Turn Into
• Using Templates

Module 20a: Report Block Types Demo

Module 21: Creating Section Reports

• Relative Positioning
• Sectioning a Report
• Formatting the Section

Module 21a: Creating Section Reports Demo

Module 22: Creating Types of Report Blocks Exercise

Module 23: Creating Charts Part 1

• Using Templates
• Using Turn Into
• Sizing Charts

Module 23a: Creating Charts Part 1 Demo

Module 24: Creating Charts Part 2

• Formatting Charts
• Changing Color Palette

Module 24a: Creating Charts Part 2 Demo

Module 25: Creating Charts Part 3

• Changing Chart Style
• Chart Dimensions
• Changing Chart Variables

Module 25a: Creating Charts Part 3 Demo

Module 26: Creating Charts Exercise

Module 27: Creating Complex Query Filters

• Creating Prompts
• Prompt Properties
• Cascading List of Values

Module 27a: Creating Complex Query Filters Demo

Module 28: Using Ands and Ors

• Creating Multiple Filters
• Using Brackets
• Mixing Ands and Ors

Module 28a: Using Ands and Ors Demo

Module 29: Creating Complex Conditions Exercise

Module 30: Intermediate Cross Tables Part 1

• Drag and Drop
• Turn Into
• Pivoting Via Headers

Module 30a: Intermediate Cross Tables Part 1 Demo

Module 31: Intermediate Cross Tables Part 2

• Displaying Row and Column Headers
• Crosstab Formatting
• Displaying Multiple Objects in the Headers

Module 31a: Intermediate Cross Tables Part 2 Demo

Module 32: Creating and Formatting Cross Tables Exercise

Module 33: Advanced Cross Tables Part 1

• Advanced Breaking
• Break Properties
• Advanced Ranking
• Rank Properties

Module 33a: Advanced Cross Tables Part 1 Demo

Module 34: Advanced Cross Tables Part 2

• Sorting/Custom Sorting
• Sorting on Properties
• Filtering on Headings

Module 34a: Advanced Cross Tables Part 2 Demo

Module 35: Input Controls

• Creating an Input Control
• Single Value/Multiple Value
• Grouping Input Controls

Module 35a: Input Controls Demo

Module 36: Advanced Cross Tables Exercise

Module 37: Conditional Formatting Part 1

• Creating Rules
• Cell Format
• Text Format

Module 37a: Conditional Formatting Part 1 Demo

Module 38: Conditional Formatting Part 2 

• Variable Format
• Applying Conditional Formatting to Cross table
• Editing and Reformatting Conditional Formatting

Module 38a: Conditional Formatting Part 2 Demo

Module 39: Conditional Formatting Exercise