Metric Calculation: APD, DTP, ABAP, or LSA?

  • by George Holdsworth, Senior Principal System Architect with Honors, Enterprise Business Intelligence, Raytheon Company
  • July 26, 2012
George Holdsworth of Raytheon explains how his team determines whether BI metrics are best calculated by the Analysis Process Designer, a Data Transfer Process, custom ABAP, or Layered, Scalable Architecture. The article includes a decision tree to help make your choice.

If your company is anything like Raytheon, your users have gone metrics crazy. Gone are the years of detailed reporting and replicating those R/3 transactions into SAP NetWeaver BW.  Today, users are into dashboards, scorecards, trends, and predictive analysis. And Google has set the performance standard very high.

So, which calculation tool should you use to calculate and store the metric data to quickly render it in BEx, SAP BusinessObjects, or any other tool?  In this case study, I discuss the pros and cons of four methods available today to accomplish this daunting task. I also include a decision tree to help you choose the best method.

George Holdsworth

George Holdsworth is a business intelligence optimizer for the Raytheon Business Intelligence team. With more than 12 years of SAP NetWeaver BW experience, he is responsible for all aspects of system architecture, data design, and system performance. 

See more by this author


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.