Web Intelligence XI R2 FastTrack

This course embraces much of the material covered on the two day Web Intelligence Report Design course, but the pace is that much quicker and the day is a little longer and intensive. 

Who should attend?

Business users who need to manipulate corporate data and format reports to answer key business questions using SAP BusinessObjects Web Intelligence

Delegates will be able to

• Define the role of universes, classes, objects, measures, dimensions and details.
• Construct queries using pre-defined and ad-hoc conditions.
• Format reports.
• Manipulate data by applying filters, sorts, breaks, calculations and ranking.
• Create cross-tabular and financial reports.
• Generate and modify charts.
• Analyse data at different levels of detail.

Prerequisites

To be successful, delegates should have a good working knowledge of Microsoft Excel or Access and/or a basic understanding of SAP BusinessObjects.

Additional education

If you want to increase your skill level and knowledge, these courses are recommended,

• SAP BusinessObjects - Web Intelligence XI R2 Advanced Report Design
• SAP BusinessObjects - Universe Appreciation Workshop
• SAP BusinessObjects - Universe Design

Topics covered

Introduction

• Web Intelligence XI
• Getting help
• Universes, Classes and Objects
• Measure, Dimension and Detail Objects
• Presentation Blocks
• Logging into Web Intelligence XI

Using InfoView

• Accessing InfoView
• The Home Page
• Accessing Public & Personal Documents
• Accessing Documents from the Inbox
• Refreshing Documents from InfoView
• Saving Documents from InfoView
• What is My InfoView
• Configuring InfoView
• Display, list & View Options
• Create & Edit Options
• Password Options
• Configuring My InfoView
• Basic Document Editing
• Logging out of InfoView

Creating New Documents with Queries

• Result Objects
• Editing Queries & Blocks
• The Query Panel
• Predefined & Ad-hoc Query Filters
• Using Wildcards in Conditions
• Prompted Queries
• Multiple Conditions and Logical Operators

Drill Reports

• Simple Drilling
• Saving a Snapshot of Analysis
• Drilling on Multiple Hierarchies in a Crosstab
• Drilling on Charts
• Drilling in HTML viewing mode

Variables and Formulas

• Report Variables
• Creating Formulas
• Converting Formulas to Variables
• Editing & Deleting Variables
• Using Formula Functions

Changing Presentation Styles

• Presentation Styles
• Vertical and Horizontal Tables
• Multiple blocks
• Crosstabs, Forms & Charts
• Changing Presentation Styles
• Converting Data to a Crosstab
• Converting Data to a horizontal Block
• Converting Data to Forms & Charts, Duplicating Blocks

Applying Functions and Sections

• Functions
• Breaks
• Simple Calculations
• Sorts
• Removing Breaks, Sorts and Calculations
• Filters
• Applying Filters to Charts & Multiple Blocks
• Sectioned Reports
• Aggregate Totals in a Sectioned Report
• Multiple blocks in a Sectioned Report
• Sizing Sections

Document Formatting

• Document Properties
• Report formats
• Table formats
• Cell formats
• Inserting and Formatting Page Numbers
• Formatting Sections & Charts

Merging Dimensions

• Creating Multiple Queries
• Arranging Dimensions
• Merging Dimensions
• Workshop – Merging Dimensions