COURSE OBJECTIVES
- Participants will gain the fundamentals of report design.
- Participants will acquire the basis for more advanced courses in the SAP BI curriculum.
Price per Person: Click Here
TARGET AUDIENCE
- Business Analysts
- Report Writers
- Report Designers
- Application Developers
- BI System Administrators
PREREQUISITES
- Basic knowledge of database concepts
Notes
- The course works with a SAP ERP 6.0 system on Enhancement Package 5 and active new general ledger (new G/L)
- Please note that the course also takes the functions into consideration on earlier releases (and on classic GL)
Course based on software release
- SAP Crystal Reports 2011
Course Outline
Report Planning
- Describing Database Concepts
- Planning and Developing a Report Prototype
SAP Business Objects BI Platform and Data Source Connection
- Logging On to SAP BusinessObjects BI Platform
- Defining a Data Source
Report Creation
- Connecting to a Data Source
- Creating a Query
- Describing the Report Design Environment
- Setting Up Report Sections
- Describing the Field Objects Controls
- Saving a Report
Report Layout and Formatting
- Setting Page Properties
- Applying Report Formatting Options
Data Selection
- Editing a Query
- Inserting Additional Filter Conditions
- Modifying Query Filters
- Applying Time-Based Filters
Sorting, Grouping, and Totaling
- Sorting Data
- Grouping Data
- Creating Nested and Multiple Groups
- Creating a Custom Group
- Grouping on Time-Based Data
- Totaling Grouped Data
- Totaling Column Data
Additional Report Objects
- Inserting Predefined Objects
- Adding Graphical Objects
Formulas
- Defining Formulas
- Using the Formula Workshop
- Creating and Modifying Formulas
- Applying Boolean Formulas
- Applying If-Then-Else Formulas
- Applying Date Calculations + Applying Numeric Calculations + Applying String Manipulation
Conditional Formatting
- Formatting Objects Conditionally
- Formatting Fields Conditionally with Formulas
- Formatting Sections
- Formatting Sections Conditionally
- Drilling Down on Sections
Charting
- Describing Charting Concepts
- Charting On Data
- Formatting Charts
Report Distribution
- Exporting a Report
- Saving Reports to SAP BusinessObjects Business Intelligence Platform