Desktop Intelligence FastTrack

Who should attend?

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

Delegates will be able to

• Understand the principles of reporting with an OLAP technology
• Describe the key features of the SAP BusinessObjects suite of products
• Define the role of universes, classes, objects, measures, dimensions and details
• Format reports (including move and resize report cells, insert titles and logos)
• Construct queries using pre-defined and ad hoc conditions
• Manipulate data by applying filters, sorts, breaks, calculations and ranking
• Create cross-tabular and financial reports
• Generate and modify charts
• Create and analyse reports using data from multiple sources

Prerequisites

Good working knowledge of either Microsoft Excel or Microsoft Access, or have previous experience in using reporting software.

Additional education

If you want to increase you skill level and knowledge, the following courses are recommended,

• SAP BusinessObjects - Desktop Intelligence Advanced Report Design
• SAP BusinessObjects - Universe Appreciation Workshop
• SAP BusinessObjects - Universe Design

Topics covered

Getting Started

• Logging on; Setting up the interface; Getting Help
• Opening Documents; Switching between reports
• Refreshing & Renaming Reports
• Saving Documents; Logging Out

Report Building

• Objects, Classes & Universes
• The Course Universe
• Building & Running Queries
• Data & Network Protection
• Editing the Results of a Query
• Exploring the Slice & Dice Panel
• The Report Manager
• Creating & Aggregating Data Blocks

Restricting Data

• Query Conditions; Single-Value Conditions
• Multi-Value Conditions; Prompted Conditions
• Wildcards; Condition Objects
• Relational Operators; Logical Operators

Manipulating Data

• Manipulating Tables
• Viewing Reports in Different Modes
• Page Layout Mode
• Structure Mode

Presentation Styles

• Block Types; selecting a presentation style
• Converting to a financial table
• Converting to a crosstab; via Slice & Dice Panel
• Converting to a chart; changing chart type and style
• Editing a chart

Drilling

• Understanding Drilling Concepts
• Hierarchies; Drill Mode; Scope of Analysis
• Using Predefined Hierarchies
• Drill Report for Single Default Hierarchy
• Scope of Analysis for Default Hierarchy
• Activating Drill Mode; Drilling on a Chart
• Drilling on Multiple Hierarchies
• Displaying Drill Information
• User-defined Custom Hierarchies

Functions

• Applying Functions
• Sorting Data
• Managing Sorts
• Custom Sorts
• Filtering Data
• Applying Calculations
• Applying Breaks
• Ranking Data

Enhancing Data

• Creating Variables
• Creating Alerters
• Grouping Data
• Calculating Variance

Grouping Data Using Sections

• Sample query; Sectioning procedure
• Aggregate totals; Multiple blocks
• Navigating sectioned reports

Synchronisation

• Document centricity; Synchronisation
• Multiple blocks from one query
• Naming a data provider
• Data from multiple queries
• Data from multiple Universes
• Linking data providers
• Working with dates
• Linking personal data
• Levels of synchronisation