BusinessObjects Web Intelligence Fast Track

Course Overview

This programme is for you if want to understand the power of BusinessObjects reporting using Web Intelligence. In a series of practical sessions, you will create queries, format reports and execute complex data manipulation. It embraces much of the material covered on the two day programme - Reporting with Web Intelligence- so the pace is that much quicker and the day a little longer than most other programmes.

Skills Gained

Delegates will learn 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

• Working knowledge of Microsoft Excel or Microsoft Access
• A basic understanding of BusinessObjects

Course Outline

Introduction

• Web Intelligence
• Getting help
• Universes, classes and objects
• Measure, dimension and detail objects
• Presentation blocks
• Logging into Web Intelligence

Using InfoView

• Accessing InfoView
• The home page
• Accessing public and personal documents
• Accessing documents from the Inbox
• Refreshing documents from InfoView
• Saving documents from InfoView
• What is my InfoView
• Configuring InfoView
• Display, list and view options
• Create and edit options
• Password options
• Configuring my InfoView
• Basic document editing
• Logging out of InfoView

Creating new documents with queries

• Result objects
• Editing queries and blocks
• The query panel
• Predefined and ad-hoc query filters
• Using wildcards in conditions
• Prompted queries
• Multiple conditions and logical operators

Changing presentation styles

• Presentation styles
• Vertical and horizontal tables
• Multiple blocks
• Cross tabs, forms and charts
• Changing presentation styles
• Converting data to a cross tab
• Converting data to a horizontal block
• Converting data to forms and charts duplicating blocks

Applying functions and sections

• Functions
• Breaks
• Simple calculations
• Sorts
• Removing breaks, sorts and calculations
• Filters
• Applying filters to charts and 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 and charts

Variables and formulas

• Report variables
• Creating formulas
• Converting formulas to variables
• Editing and deleting variables
• Using formula functions

Drill reports

• Simple drilling
• Saving a snapshot of analysis
• Drilling on multiple hierarchies in a cross tab
• Drilling on charts
• Drilling in HTML viewing mode

Merging dimensions

• Creating multiple queries
• Arranging dimensions
• Merging dimensions
• Workshop - merging dimensions

Review of Programme

Follow On Courses

• BusinessObjects Advance Reporting with Web Intelligence

BusinessObjects Web Intelligence Fast Track / BOWEBFAS