SAP BO

Module 1 - Introduction to SAP BO (Business Objects)

What is SAP BO?

View, analyze and sort BI data using BI

Components of BO

Crystal reports

Web intelligence tool

Ad hoc queries

Module 2 - Data Warehousing

Introduction to data warehousing

Deployment in real world scenarios

Features of data warehousing

Data marts and tables

Star schema and multiple star schema

Module 3 - Database in SAP BO

Overview of database

Characteristics of database

DCL, DML, DDL, TCL

Data types of tables structuring

Set Operators

Join types and conditions

Group By

Having and Where conditions

Numeric Functions, Character Functions, Date Functions, Aggregate Functions

Module 4 - Life Cycle Management

FDD features

BRD business requirements

Technical design

Project plan

Execution

Preparation of unit test case

Deployment check list

Module 5 - Requirements of BO

Backend non SAP apps

Comprehension of SAP BW and BI

HANA expertise

ODBC connections

Module 6 - BO Universe

Universe designer tool

Personal connection

Shared connection

Linked universe

Secured connection

Information Designer tool

Local connection

Secured connection

Data foundation connection, parameters, etc

Business layer, parameters, etc

Conditions

Developing objects and types

Managing security

Trap issues and derived tables

Hiding and un-hiding objects

Table creation

Usage of @functions – @ Prompts

Usage of @Where

Usage of @Select

Usage of @Aggregate Awareness

Data integrity & Business layer

Single data source and multiple data sources

Performance tuning techniques

Business Intelligence Consumer Services (BICS)

Module 7 - Business Intelligence Reports 4.2

Adhoc Reports

Overview of web reporting

Creation Query & Report, view, modifying report

Filters and other operators

Section vs break

Alerter, sorting and ranking

Merged queries and dimensions

Types of charts and usage

Special functions

Transforming horizontal and vertical cross tabs into charts

Hyperlinking

Input controls

Crystal reports

What is Crystal reports?

Repository explorer and database expert

Report Templates and inbuilt functionalities

SAP platform interaction

RDBMS interaction

MS access interaction

Standard, blank and cross tab report

Different data source connections

Maintenance and scheduling

Development of CR with and without universe

Working with charts, dashboard and sub-reports

Groups and calculations

Web Intelligence Report

Introduction of web reporting

Charts, types of charts and various usage

Info Providers and Data Providers

Working with special Functions

Formation of reporting

Converting Horizontal, Vertical, Cross Tabs into Charts

Developing query’s and Drilling Functionalities

Viewing and Modifying a report Purging of objects

Query Filters & various operators

Export Options (PDF, excel, CSV etc.,)

Query Prompts Document Properties/Formatting

Sections/ Breaks

Input Controls

Report Level Variables

Difference between Section & Break

Hyper Linking Functionalities

Alerter

Usage of Web Intelligence Rich Client Application

Ranking, Scheduling of Webi Report and Sorting

Folding and Unfolding of Reports

Merged Dimensions

Combined Queries

Canned Reports

Module 8 - Dashboards

Overview of dashboards

Features of types of dashboards

Information providers

Creating dashboard

Static and dynamic dashboard

Work with dual axis dashboard, data by range, series, Calender and bar chart dashboards

Import and export of data

Data management

Different layers (data, canvas, components, properties)

Query builder

QAAWS connectivity

Module 9 - BI Launch Pad

Creation of web intelligence reports

Scheduling crystal and webi reports

Transferring crystal and webi repors

Data storage

Folder structuring

Module 10 - Performance Tuning Techniques

Universe level tuning

Report level tuning

Database level tuning

Query optimization methods

Module 11 - Additional Reporting Applications

SAP Lumira

Widgets

BO Explorer

Query as a web service

Module 12 - Error Handling Techniques

Real-time error handling methods

Different scenarios

Troubleshooting

Module 13 - Project Explanation

Overview of project life cycle

Project domain

Template and workflow design

Requirement of report templates