BusinessObjects 6.5: Reporting: Level 1 (Core)

Course Overview

This course introduces you to the power of BusinessObjects reporting. In a series of practical sessions you will create queries, format reports and execute complex data manipulation.

Audience

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

Skills Gained

• Understand the principle of reporting with an OLAP technology.
• Define the role of universes, classes, objects, measures, dimensions and details.
• Format reports (including move & resize report cells, insert titles & logos).
• Construct queries using pre-defined and ad-hoc conditions.
• Manipulate data by applying filters, sorts, breaks, calculations and ranking.
• Create cross-tabular & financial reports.
• Generate & modify charts.

Prerequisites

Good working knowledge of either Microsoft Excel or Microsoft Access or have previous experience in using reporting software. Ability to navigate the desktop.

Course Outline

Introduction to BusinessObjects

Universes, Classes and Objects. Measures, Dimensions & Details. Presentation Blocks. Logging On.

Formatting in BusinessObjects

Formatting Cells. Inserting Titles & Logos. Moving & Resizing Cells. Duplicating & Renaming Reports. Report Manager. Refreshing Data. Saving Reports.

Querying

Results Objects. Editing Results Objects. Query Panel. Predefined Conditions. Ad-hoc Conditions.Pattern Matching. Prompted Queries. Setting the Precedence.

The Slice and Dice Panel

Moving Data. Applying Filters. Sorting Columns. Custom Sorts. Breaking the Block. Simple Calculations. Ranking Data. Master Detail Reports. Folding and Outlining. Cross-tabular & Financial Blocks. Creating & Modifying Charts. Reset versus Apply.

Report Structure

Report Variables. Alerters. Grouping. Variance.

Drilling

Extending the drilling path.Drilling on Multiple Hierarchies.