The SAP BW HANA Analysis Process: Improve Data-Mining with the New Features of SAP BW 7.4

  • by Ned Falk, Senior Education Consultant, SAP
  • May 25, 2015
Learn the technical underpinnings and practical steps needed to use the new SAP BW 7.4 HANA Analysis Process. This new tool improves on and complements the existing Analysis Process Designer (APD) as a way to execute data-mining algorithms and stored procedures using the power of SAP HANA via an SAP BW interface.
Learning Objectives
Reading this article, you will learn:

  • How to more effectively use data mining algorithms
  • How to review the purpose and positioning of the Analysis Process Designer (APD)
  • The technical underpinnings of the new SAP HANA Analysis Process (HAP)
  • How to create and execute a HAP
  • The options of tying a HAP with an APD and why you might want to
Key Concept
The SAP HANA Analysis Process tool is an SAP BW 7.4 feature for customers running SAP BW on SAP HANA. It allows the SAP BW modeler access to powerful predictive analysis (data mining) algorithms and stored procedures that execute on the database, not in the application server as was the case with older SAP BW Analysis Process Designer tool.

Data mining can be loosely defined as using statistical (math) algorithms or models to uncover meaningful information in large datasets that could not be gleaned by simply looking at a report. Real-life examples of data mining include Amazon’s people like you (e.g., a clustering algorithm) also bought this book (e.g., an association analysis algorithm), or the National Security Agency (NSA) and Transportation Security Agency (TSA) use of data mining to identify terrorists or predict faults or breakdowns in systems before they occur. (Many other examples can be found at this link: Data-mining examples.)

The previous versions of SAP BW the Analysis Process Designer (APD) was the go-to tool to perform data-mining tasks in SAP BW. Now, for companies running SAP BW on SAP HANA, the new SAP HANA Analysis Process tool that comes with SAP BW 7.4 can execute more complex algorithms faster.

I discuss how to better use (and understand the reasons to use) data-mining algorithms, and give an overview of the older APD tool. I then discuss the new SAP HANA Analysis Process (HAP) tool, how to create and execute a HAP, how to tie a HAP with an APD, and scenarios where this would be required.

For more information about APD, read this BI Expert article, “Uncover Hidden Trends in Historical Data with Analysis Process Designer.”
To learn more about PAL, watch this video:

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

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.