ABAP Dataflow & TransportS in BODS

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software.

This  post introduces the SAP BusinessObjects Data Services objects for extracting data from SAP application sources:
• SAP Applications datastores
• ABAP data flows
• transports Continue reading “ABAP Dataflow & TransportS in BODS”

Multiuser functionality in SAP Data Services

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software.

In this post you will create two local repositories and one central repository and perform the tasks associated
with sharing objects using Data Services. Continue reading “Multiuser functionality in SAP Data Services”

Recoverable workflow in BODS

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software.

This post describes on how to:

• Design and implement recoverable work flows.
• Use Data Services conditionals.
• Specify and use the Auto correct load option.
• Replicate and rename objects in the object library.

Continue reading “Recoverable workflow in BODS”

CDC in BODS

Changed-Data Capture

This post introduces the concept of changed-data capture (CDC). You use CDC techniques to identify changes in a source table at a given point in time (such as since the previous data extraction). CDC captures changes such as inserting a row, updating a row, or deleting a row. CDC can involve variables, parameters, custom (user-defined) functions, and scripts. Continue reading “CDC in BODS”

Joins and Lookup in SAP Data Services

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software.

 

This post discusses on join conditions and look up in Data Services.

Populating the Sales Fact Table from Multiple Relational Tables

Continue reading “Joins and Lookup in SAP Data Services”

Debugger in SAP Data Services

This post describes on how to use debugger in Data Services.

Using the interactive debugger

The Designer includes an interactive debugger that allows you to examine and modify data row by row by placing filters and breakpoints on lines in a data flow diagram.
A debug filter functions as a simple query transform with a WHERE clause. Use a filter to reduce a data set in a debug job execution. A breakpoint is the location where a debug job execution pauses and returns control to you.
This exercise demonstrates how to set a breakpoint and view data in debug mode. Continue reading “Debugger in SAP Data Services”

SAP Data Services Designer tool

This post gives you a short overview of the Data Services product and terminology.

Data Services Components

The following diagram illustrates Data Services product components and relationships-

Continue reading “SAP Data Services Designer tool”

SQL Transform in Data Integrator

SQL Transform: You can write your own customized SQL query here. It appears in your dataflow as a source. Use this transform when you cannot perform using other DI transformations. Whatever the SQL entered, it will not be validated by DI. Continue reading “SQL Transform in Data Integrator”

Map Operation in BODS

Map Operation in Data Services Designer allows conversions between data manipulation operations.  Using Map_Operation transform you can change operation codes on data sets to produce the desired output. Continue reading “Map Operation in BODS”