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”

Direct Data Access DTP – SAP Remote Cube or Virtual InfoCube

This post is just for demonstrating the use of virtual infocubes and direct access DTPs as these are not used so frequently while modeling.

There is no data acquisition and the BI system connects remotely to the source when the query is called by the user. This is particularly useful where very less data need to be retrieved and it changes frequently.

There is also a concept of using Open ODS views if your BW system is based in HANA, where there is a similar access to source tables directly and queries are based on the source fields. Continue reading “Direct Data Access DTP – SAP Remote Cube or Virtual InfoCube”

SAP Netweaver BI Accelerator

Tcodes: RSDDV, RSADMIN

BIA

BI Accelerator is a separate server which runs on TREX (Text Retrieval Extraction). The BI-Accelerator is a an addition to SAP BW 7 version and is now becoming obsolete with the advent of HANA.

BIA serves the purpose of putting some of the data in the memory whereas HANA puts all the data in memory.

Many companies have opted for BIA when it was launched and it has given impressive performance with typical improvement factors between 10 and 100.

Long running Sales/AR/Finance queries have improved drastically when the cubes on which they are based are indexed on BIA. Continue reading “SAP Netweaver BI Accelerator”