COURSE DETAILS & CURRICULUM
Fundamentals of Report Design
- Report Concepts
o Describing Reporting Concepts
- Report Creation
o Choosing a Report Creation Method
o Connecting to Data Sources
o Navigating in the Design Environment
o Inserting Objects in a Report
o Previewing a Report
o Saving a Report
o Setting the Position and Size of Objects
o Formatting Objects
- Record Selection
o Setting Records Using Select Expert
o Saving and Refreshing Data in Reports
o Setting Additional Criteria
o Applying Time-Based Record Selection
- Report Data Sorting, Grouping, and Summarizing
o Sorting Records
o Creating a Grand Total
o Grouping Records
o Managing Multiple Groups
o Grouping on Time-Based Data
o Summarizing Data
o Sorting and Filtering Groups
o Sorting Groups using Specified Order
- Graphics and Special Fields
o Adding Graphical Elements
o Adding Special Fields
- Section Formatting
o Formatting Sections
o Controlling Page Breaks
o Creating Summary Reports
- Basic Formulas
o Defining a Formula
o Creating If-Then-Else Formulas
o Creating Boolean Formulas
o Creating Formulas with Dates
o Creating Summary Functions in Formulas
o Applying String Manipulation
- Conditional Reporting
o Highlighting Data in a Report
o Formatting Data Conditionally
- Charts
o Creating Charts Without Groups
o Creating Charts Based on Existing Groups and Summaries
o Customizing a Chart on a Simple Report with No Groups
- Report Distribution
o Exporting a Report
o Saving a Report to SAP BusinessObjects Business Intelligence Platform
Business Reporting and Report Processing Strategies
- Report Wizard
- Running Totals
- Alerts
- Functions
- Control Structures
- Variables
- Templates
- Parameters
- Additional Parameters Properties
- Additional Applications for Parameters
- Dynamic List of Values for Parameters
- Arrays
- Crosstabs
- Custom Functions
- Sections
- Introduction to Subreports
- Linked Subreports
- Report Linking Report Processing
Optimizing Report Data Processing
- Identification of link and join types
- Setup and configuration of data sources
- Updating a report for database changes
- Server-side data processing
- Report data validation
- Problem detection and fixes
Fundamentals of Report Design
- Report Planning
o Describing Database Concepts
o Planning and Developing a Report Prototype
- SAP Business Objects BI Platform and Data Source Connection
o Logging On to SAP BusinessObjects BI Platform
o Defining a Data Source
- Report Creation
o Connecting to a Data Source
o Creating a Query
o Describing the Report Design Environment
o Setting Up Report Sections
o Describing the Field Objects Controls
o Saving a Report
- Report Layout and Formatting
o Setting Page Properties
o Applying Report Formatting Options