BusinessObjects 6.5: Reporting: Fast Track

About this class

This challenging one-day 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. The pace of the course is that much quicker and the day a little longer than most other courses.

Who will the lesson benefit?

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

What delegates will learn

After completing the course, learners will be able to:

• Understand the principle of reporting with an OLAP technology
• Describe the key features of the BusinessObjects suite of products
• 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 Create & analyse reports using data from multiple data sources

What prerequisites are required

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

Ability to navigate the desktop

Contents of this class

• 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 & 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
• Outlining Reports
• Outlining; Semantic Dynamism