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





 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)