Tag Archives: SAP BODS Tutorials

SAP BODI/BODS Online Training

SAP BODI/BODS Online Training Course Content

Introduction to Data Warehouses, Data Marts and ETL Process 1 Hour and 30 Mins
  • Operational systems and their characteristics
  • Analytical systems (or DWHs) and their characteristics
  • Data Marts
  • Comparison of (a) Operational systems and Analytical systems and (b) Data Warehouses and Data Marts
  • Basic Data Warehouse Architecture – various layers
  • Facts and Dimensions – An example Star schema
  • Slowly Changing Dimensions – Type 1, Type 2 and Type 3 with examples
  • What is ETL – Extraction, Transformation and Load
  • Extraction types – Full and Incremental
  • Load types – Full and Incremental
Introduction to BO Data Services 45 Mins
  • Standard Data Services Achitecture – Designer, Repository, Job Server, Engine, Access Server, Administrator, Web Server and Service
  • Basic Data Services Components – Designer, Server Manager, Repository Manager and Management Console
  • Data Services Objects and Object Hierarchy
Preliminary workouts with Data Services 30 Mins
  • Create a local respository using Repository Manager
  • Configure a job server using Server Manager
  • Associate repository to the Job server
  • Connect repository to the Administrator
Working with Designer
  • Logging into the Designer 15 Mins
  • Walk through of Designer User Interface 15 Mins
  • Create and execute a simple Batch Job 3 Hours
    • Create DataBase DataStore and import metadata
    • Create and edit File formats (.txt, .csv, .xls), File format features
    • Create Data Flow, Work Flow, Job and Project
    • Execute the job and monitor its progress
  • 4.4 Built-in Transforms – All important DI, DQ and Platform Transforms 8 Hours
  • 4.5 DS Scripting Language and working with Functions 4 Hours
    • Script and the scripting language
    • Built-in functions (Important functions such as exec, ifthenelse, decode, is_valid_date, lookup, lookup_ext, lookup_seq, nvl, and sql
    • Custom functions, Database functions and stored procedures
  • 4.6 Other important Objects 2 Hours
    • Conditional
    • While loop
    • Try
    • Catch
    • Annotation
  • Working with variables and parameters 1 Hour
      • Global variables
      • Local variables

    Page 1
    ID S. No. Topic Duration

  • Parameters
  • Working with nested data – extracting data from XML sources 1 Hour
  • Debug features 1 Hour
    • using “View Where Used”
    • using “View Data”
    • using the interactive debugger
  • Working with Full sources, Time stamped sources and CDC sources 4 Hours
    • Implementing type 1 SCD – Full extraction
    • Implementing type 2 SCD – Full extraction
    • Implementing type 1 SCD – Incremental extraction (Time stamped source)
    • Implementing type 2 SCD – Incremental extraction (Time stamped source)
    • Implementing type 1 SCD – Incremental extraction (CDC Source)
    • Implementing type 2 SCD – Incremental extraction (CDC source)
    • Benefits of Incremental extraction over full extraction
Working in multi user environment 1 Hour
  • Setting up multi user environment – Creating, defining a connection to and activating Non-secure and Secure central repositories
  • Accessing central repository from a local repository – Adding objects, Checking out objects, Undoing check out, Checking in objects,Filtering, Getting objects, Labeling objects, Comparing objects, Viewing object history and Deleting objects
Code migration from one phase to another phase of a project 1 Hour
  • Using Export/Import method
    • ATL method
      • Exporting objects to file (.ATL)
      • Exporting whole repository to file (.ATL)
      • Importing from .ATL file
    • Directly exporting objects from one repository to another repository
  • Using central repository method
Processing data with problems 1 Hour
  • Using overflow files
  • Pass bad data to a database table for further analysis and action
Recovering from unsuccessful job execution 30 Mins
  • Automatic Recovery
  • Manual Recovery
DS Management Console
  • Administrator 2 Hours
    • Walk-through of Administrator UI
    • Management – Adding repositories, Managing user roles and Setting the log retention period etc.
    • Central repository users and groups management
    • Server group – Achitecture, Executing jobs using SG and the advantage of load balancing
    • Executing, scheduling and monitoring batch jobs
    • Troubleshooting – Understanding error and trace logs
    • Use of Export execution command option
  • Using Impact and Lineage Analysis reports 15 Mins
  • Using Operational Dashboards 15 Mins
    Page 2
    ID S. No. Topic Duration
  • Using Auto Documentation 15 Mins
Loading a tiny DWH
Loading a tiny DWH – Customer Dim from relational sources, Location Dim from flat file sources, Product Dim from xml sources, Time Dim from relational sources and Revenue Fct from relational sources; Managing dependencies between jobs.
3 Hours
Performance Tuning 4 Hours
  • 11.1 Using DB Indices properly
  • Maximize Push-Down using Data_Transfer transform and pushdown_sql function
  • Using proper caches
    • Sources – In-memory or Pageable
  • Maximize Parallel execution where possible using Table partitioning and DOP option
  • Splitting data flow into sub data flows using “Run as separate process” option
  • Using Bulk Loading option
  • Using Join ranks and array fetch size options
  • Using Rows per commit option
A brief view of repository tables
ID S. No. Topic Duration
Top ↑