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

Java 9 Programming for Object Oriented (OO) Experienced Developers (TT2100J9)

Java 9 Programming for Object Oriented Experienced Developers is a five-day, comprehensive hands-on introduction to Java training course geared for developers who have prior working knowledge of object-oriented programming languages such as C# or C++.ï¿½ Throughout the course students learn the best practices for writing great object-oriented programs in Java 9, using sound development techniques, new improved features for better performance and new capabilities for addressing rapid application development.ï¿½ In addition to the normal exercises that are liberally sprinkled throughout the course, there is a case study that covers the entire spectrum from use cases to object-oriented design to implemented classes.ï¿½ This case study supplements the course and can be used during and after the course as a reference and a tool for reviewing and practicing what was learned in class.ï¿½ï¿½

Note: Students new to OO programing or from a Non-OO Development background (such as C, COBOL, Visual Basic, etc.) should consider the TT2120-J9 Java 9 and OO Essentials for Developers New to OO or the TT2125-J9 Java and OO OnRampï¿½ program as an alternative.

Uncategorized

WebSphere Application Server V8.5 Scripting and Automation

This 5-day self-paced course teaches you the skills that are required to automate the administration of a WebSphere Application Server V8.5 environment.

Most administrative tasks are multi-step and repeatedly used, and GUI-based administration tools can quickly become impractical and even a burden. WebSphere Application Server offers a collection of tools and technologies that you can use to create automated scripts, facilitating system administration

The course describes the scripting facilities in WebSphere Application Server and teaches you how to use the Jython language with WebSphere administrative objects to develop scripts that automate common administrative tasks.

Hands-on exercises throughout the course reinforce lecture content and give you practical experience with the WebSphere Application Server V8.5 scripting environment. Exercises include tasks such as creating and configuring an application server environment, installing and configuring the IBM HTTP Server, and automating the installation of WebSphere Application Server.

Uncategorized

IBM Cognos Analytics: Author Reports with Multidimensional Data (v11.0)

This course is designed to guide report authors in building their expertise with IBM Cognos Analytics by applying dimensional techniques to reports. Through interactive demonstrations and exercises, participants will learn how to author reports that navigate and manipulate dimensional data structures using the specific dimensional functions and features available in IBM Cognos Analytics.

Uncategorized

Introduction to Artificial Intelligence (AI), AI programming & Machine Learning

Introduction to AI, AI Programming & Machine Learning is a 3-day hands-on course that course introduces the field of artificial intelligence (AI). ï¿½Materials on AI programming, logic, search, game playing, machine learning, natural language understanding, and robotics introduce the student to AI methods, tools, and techniques, their application to computational problems, and their contribution to understanding intelligence. ï¿½ï¿½

This course presents a wide variety of related technologies, concepts and skills in a fast-paced, hands-on format, providing students with a solid foundation for understanding and getting a jumpstart into working with AI and machine learning. Each topic area presents a specific challenge area, current progress, and approaches to the presented problem.