Error Stack in SAP NetWeaver BI Provides Improved Data Load Error Handling

  • by Amol Palekar, Principal Consultant, TekLink International, Inc.
  • Bharat Patel, SAP BW System Manager, Bharat Petroleum, India
  • Shreekant W. Shiralkar, Global Head, SAP Analytics CoE, Tata Consultancy
  • April 1, 2008
SAP NetWeaver BI 7.0 introduces new functionality for error handling, such as the error Data Transfer Process and error stack. Find out how to use these new options.
Key Concept

SAP NetWeaver BI 7.0 contains a modified data staging and distribution process, called the Data Transfer Process, as a part of the extraction, transformation, and loading process. This element provides an efficient mechanism for error handling because it splits the staging, distribution, and loading process. In addition, a request-based database table called the error stack isolates erroneous records.

During design time or day-to-day operations, the error handling features in extraction, transformation, and loading (ETL) ensure the quality of data by eliminating data-related errors. This is important when your data warehouse acquires data from different source systems. The cleansing and transformation (technical or semantic) of data before loading it to the data targets should be a regular activity.

When you acquire and load data from varied source systems, data load errors are normal. The options available in your system determine how it processes and responds to errors. Regardless of which option you use, you must separate the error records from the entire data set for correction before loading them to the intended data target.

In this first article of a two-part series, we discuss the different options available in SAP NetWeaver BI 7.0 for error handling. We explain the Data Transfer Process (DTP) by using a scenario in which an InfoCube is the data target. In the second article we’ll show an example that involves a DataStore object (DSO) as the data target.

Amol Palekar

Amol Palekar has worked on BI implementations for various Fortune 500 companies. He is currently principal consultant at TekLink International, Inc., and focuses on institutionalizing the global delivery model and processes for application development, maintenance, and support engagements. He is also a trainer, author, and regular speaker on the subject of BI. He is recognized for his popular and best-selling books: A Practical Guide to SAP NetWeaver BW (SAP PRESS) and Supply Chain Analytics with SAP BW (Tata McGraw-Hill).

See more by this author

Bharat Patel

Bharat Patel is experienced in managing data warehouse technology for the petroleum industry. He is an SAP-certified BW and ABAP consultant, has authored a book on SAP BW, and teaches courses on BW and ABAP at the Sapient Academy and SAP Labs India. Bharat has presented papers about BW at Business Intelligence India Group (BIIG) conferences. He presently manages the SAP BW system at Bharat Petroleum, India.

See more by this author

Shreekant W. Shiralkar

Shreekant W. Shiralkar is a senior management professional with experience on leading and managing business functions as well as technology consulting. He has authored best selling books and published many white papers on technology. He also holds patents for innovations. Presently he is global head of the SAP Analytics Centre of Excellence at Tata Consultancy.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.