Business Objects Desktop Intelligence Advanced Reporter Course - Canada

Business Objects Desktop Intelligence Advanced Reporter Course Outline

This Business Objects Desktop Intelligence Advanced Reporter Course is comprised of the following subjects:

Editing Reports:

• Editing Blocks
• Applying and Formatting Filters
• Applying and Formatting Sorts

Formatting Reports:

• Creating and Using Templates
• Page Formatting Options
• Formatting Tables and Sections
• Adding Page Breaks
• Formatting Charts
• Aligning Cells and Blocks

Restricting Data with Conditions:

• Multi-Value Conditions
• Using Logical Operators (AND/OR)
• Pre-Defined Conditions
• Prompted Condition Queries
• Using Wildcards in Queries
• Displaying Prompt Criteria in Reports
• Creating Subqueries
• Combine Queries (Union, Intersect, and Minus)

Using Multiple Data Providers:

• Understanding Data Providers
• Multiple Queries from a Single Universe
• Naming and Using Data Providers
• Querying Multiple Universes in a Single Document
• Using Personal Data Files (e.g., Microsoft Excel Spreadsheets) as Data Sources
• Synchronising Data Providers by Linking
• Numeric Data Format Issues

Defining and Using Variables:

• Creating Variables
• Resetting Calculations Across Breaks
• If/Then/Else Variables
• The Group Function
• Creating a Variable Using the Group Function
• Understanding Calculation Contexts

Using Slice and Dice:

• Slice and Dice View
• Converting Tables to Crosstabs
• Converting Table Blocks to Charts
• Adding Breaks, Totals, Filters, and Other Functions

Drilling:

• Understanding Hierarchies
• Setting the Scope of Analysis
• Pre-Defined Hierarchies
• Drilling on Single and Multiple Hierarchies
• Creating Custom Hierarchies
• Drilling on Charts
• Displaying Drill Information
• Saving Snapshots

Exporting Data for Use in Other Applications:

• Exporting Data from a Block
• Exporting Data from a Data Provider