SAP Business Objects Data Services

 

 

 

  • Introduction

 

What is Data Warehouse

 

Data Warehouse Functions & Implementation

 

Data Warehouse Products & Venders

 

About SAP’s DatawareHouse-SAP BW

 

SAP BW functions, Benefits & Limitations

 

About Business Objects & their Products

 

Why SAP Acquired Business Objects

 

Data Centric Vs Process Centric DWH system.

 

 

 

  • SAP BO Data Service Overview

 

About Data Services - Introduction

 

Functions - Data Integration & Data Management

 

Data Services Product Evolution(ATL, DI & DQ)

 

Architecture – by Components

 

Data Services Tools & its functions

 

Data Services Objects & Objects Hierarchy

 

BODS Objects Naming standards

 

BODS Objects comparison with SAP BW Objects

 

 

  • Data Services - Basic Level:

 

Repository Manager-BODS Repository

 

Repository Types- Local, Central, Profile

 

Repository Creation & Up gradation

 

Server Manager-Job Server(JS) & Access Server(AS)

 

JS & AS Creation, Job Server-Repository Assignment

 

Management Console – Introduction & Components

 

Data Service Designer – Introduction & GUI

 

Getting Started with Designer to Develop First ETL Flow

 

 

  • Data store & Formats

 

Datastore-Overview & Types

 

Datastore Creation - DB,SAP, Adopter, Web Service

 

Formats – Flat files, Excel, DTD, XSD, COBAL Copybooks

 

Data Extraction from Database Tables

 

Data Extraction from Excel Workbook – Multiple Sheets

 

Data Extraction from Flat files ( CSV, Notepad, SAP Transport)

 

Data Extraction from XML File ( DTD, XSD)

 

Data Extraction from COBOL Copybooks

 

Data Distribution to Flat File & XML

 

Dynamic Extraction – Files Selection & Sheet Selection

 

 

  • Data Services-Transforms

 

Transforms & Categories (DI, DQ, PF)

 

Data Integration – Data_Transfer, Date_Generation

 

Data Integration – Effective_Date, Hierarchy_Flattening

 

Data Integration – History_Preserving, Key_Generation

 

Data Integration – Pivot, Reverse_Pivot, XML_Pipeline

 

Platform – Case, Map_Operation, Merge, Query

 

Platform – SQL, Validation Custom ABAP Transform

 

 

  • Data Services-Advance Level

 

BODS Admin Console – Administration, Auto Reporting.

 

Real time Jobs, Embedded Data Flows Variables, Parameters,

 

Substitution Parameters, System Config

 

Debugging, Recovery Mechanism

 

Data Assessment – Data Profiling

 

BODS Performance Tuning Techniques

 

Multi-User Development Environment - Intro & Advantages

 

Multi-User Environment Implementation & Migration

 

BODS Object Migration Techniques

 

 

  • Data Services-SAP Systems Handing

 

SAP System – Intro, SAP System allowed, Terminology

 

SAP BODS and SAP ERP / SAP BI Integration

 

SAP BODS User & Role creation in SAP

 

SAP ERP – Data Flow, Interfaces, Objects allowed to BODS

 

Creation SAP Application Datastore – Properties

 

SAP ERP – Tables & Hierarchies Data Extraction

 

SAP ERP – Getting RFC enabled Functions Modules

 

SAP ERP – IDOC Data Extraction & IDOC Data Loading

 

SAP ERP - Extraction Flat file data from SAP APP Server

 

SAP BW - Data flow, interfaces, Objects allowed to BODS

 

Creating SAP BW Source and SAP BW Target Datastores

 

SAP BW – Extracting Data from

 

SAP BW info providers – OHD

 

SAP BW – Extracting Data from SAP BW Bases tables-/BIC/

 

SAP BW – Loading Data to SAP BW info providers(MD & TD)

 

SAP BW – BW Jobs Execution

 

 

  • SAP BOBJ RAPID MARTS:

 

 Rapid Marts – Introduction, Advantages, Limitations

 

Total Rapid Marts SAP offering, Rapid Marts for SAP Solution

 

Rapid Marts – Versions, Dataflow, Content

 

Why and Whom to go for Rapid Marts implementation?

 

Rapid Marts implementation Out of Box:

 

- Environment Checklist

 

- Recommend for Upgradation

 

- Environment setup ( Pre installation phase)

 

- Installation of RM(Data Model, ETL, Visuals)

 

- Configuration of RM ( ETL, Visuals)

 

- RM File and Custom ABAP Transform Maintenance

 

- Rapid Mart directory Maintenance

 

Rapid Marts Testing - Sample Data Loads, Testing Reports

 

Rapid Marts Recovery Mechanism – For Delta Loads

 

Rapid Marts implementation – Customization (as per Req.)

 

- Data Model Customization

 

- ETL Customization

 

- Visuals Customization

 

Rapid Marts Performance Tuning Techniques (Standard)