SAP Crystal Reports for Enterprise: Fundamentals of Report Design (BOCE10)

COURSE OUTLINE:

Description

Participants will gain the fundamentals of report design and acquire the basis for more advanced courses in the SAP BI curriculum.

Audience

Business analysts
System administrators

Prerequisites

Essential

Knowledge of Windows Conventions

Recommended

Basic database concepts

Learning Objectives

Plan and create a report
Organize and format data
Apply record selection
Create formulas and apply conditioning report
Export and distribute reports

1. Report Planning

Describing Database Concepts
Planning and Developing a Report Prototype

2. SAP Business Objects BI Platform and Data Source Connection

Logging On to SAP BusinessObjects BI Platform
Defining a Data Source

3. 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

4. Report Layout and Formatting

Setting Page Properties
Applying Report Formatting Options

5. Data Selection

Editing a Query
Inserting Additional Filter Conditions
Modifying Query Filters
Applying Time-Based Filters

6. 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

7. Additional Report Objects

Inserting Predefined Objects
Adding Graphical Objects

8. 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

9. Conditional Formatting

Formatting Objects Conditionally
Formatting Fields Conditionally with Formulas
Formatting Sections
Formatting Sections Conditionally
Drilling Down on Sections

10. Charting

Describing Charting Concepts
Charting On Data
Formatting Charts

11. Report Distribution

Exporting a Report
Saving Reports to SAP BusinessObjects Business Intelligence Platform

RELATED COURSES

Uncategorized

Configuration Management with Puppet (DO405)

This course is designed for system administrators and cloud administrators who intend to implement Puppet as integrated with Red Hatï¿½ products in an operations environment or a cloud computing environment.

This course is on Red Hat Enterprise Linuxï¿½ 7 and Red Hat Satellite 6.

Uncategorized

VMware NSX-T: Install, Configure, Manage [v2.2]

This five-day course provides comprehensive training on how to administer a VMware NSX-Tï¿½ environment. This course covers key VMware NSXï¿½ features and functionality offered in the NSX-T 2.2 release operating across layer 2 through layer 7 of the OSI model.

ï¿½

Access to a software-defined data center environment is provided through hands-on labs to reinforce the skills and concepts presented in the course

Uncategorized

PowerVM on IBM i-II: Advanced Topics and Performance

Learn the objectives, prerequisites, installation, and managing steps of PowerVM advanced features like Suspend/Resume, Active Memory Sharing, Live Partition Mobility, and Shared Storage Pools. All learning materials are primarily focused on IBM i as a client partition and dual VIOS as host environment. Part of this course is a presentation of the tools for monitoring a virtualized environment.

Uncategorized

AWS Certification Exam Readiness Workshop: AWS Certified Solutions Architect – Associate

Designed to complement Architecting on AWS, this half-day workshop is ideal for individuals who are preparing for the AWS Certified Solutions Architect – Associate exam. In this workshop, you will learn what to expect at the testing center and while taking the exam. We walk you through how the exam is structured, including question formats, content domains, and the breakdown of questions across those domains. You will also learn how to interpret the concepts being tested by a question so that you can better eliminate incorrect responses. During the workshop, you will have the chance to apply knowledge and test concepts through a series of practice exam questions.