How to Execute SAP Bank Analyzer ETL Automation

  • by Pinckney Ma, Independent Consultant
  • February 28, 2013
Follow the steps to implement a method to automatically execute the SAP Bank Analyzer Data Load Layer process chains.
SAP Bank Analyzer is an SAP financial service module that contains several layers used for extracting and analyzing bank data.

A kernel component of SAP Bank Analyzer is the Data Load Layer. It loads bank data from the Source Data Layer to the Results Data Layer. The data-loading processes are built in an SAP NetWeaver Business Warehouse (BW) process chain. A process chain contains many process steps. They are linked and look like a chain. Any step failure in a process chain usually needs operator intervention to resume the execution. I describe a method to automatically execute the Data Load Layer process chains based on a successful implementation at Canada ABT bank. The method simulates a three-step process:

  1. Save the error logs if a step failure occurs. A step failure means that the bank received customer data with data range, format, or syntax errors that the system detected and cannot be automatically corrected.
  2. Rerun the failure steps
  3. Continue the execution of throughout the remainder of the process chain

I provide an ABAP program for writing error information into an SAP table and an ABAP program to read the error log information.

Pinckney Ma

Pinckney Ma is an independent SAP NetWeaver Business Warehouse (SAP NetWeaver BW) consultant. Previously, he worked as a senior consultant at BearingPoint and Knightbridge. Pinckney is certified in SAP BW 3.5 and SAP NetWeaver BW 7.0. He earned his Ph.D in computer engineering and has 20 years of IT experience, including over 10 years in data warehouse and SAP NetWeaver BW implementation experience. He has worked on SAP NetWeaver BW implementations in many areas, as well as other SAP modules including FI, CO, profitability analysis (CO-PA), sales and distribution (SD/OTC), Advanced Planning & Optimization (APO), materials management (MM), SAP BusinessObjects Global Trade Services, and Flexible Real Estate Management (RE-FX).

See more by this author


Comments

7/1/2013 3:27:22 PM
Ram Sharma

Can you outline the purpose of SAP Bank Data Analyzer...what does it analyze...transactions or master data or and/or other things as well...any help you can provide is appreciated..
Thanks
Ram

Please log in to post a comment.

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