Data Mining with the Analysis Process Designer in SAP BW 3.5

  • by Glen Leslie, BI Product Manager, SAP Labs
  • May 1, 2004
The Analysis Process Designer (APD) workbench, introduced in BW 3.1 Content (BW 3.0B SP6), allows users to combine numerous transformations into a single data flow. It offers a less technical approach to enhancing subject-oriented, non-volatile data that has already been integrated, cleansed, and transformed in the data warehouse. The author examines current APD features and outlines future plans for integrating it with other data mining functionality in the upcoming BW 3.5 release set for later this year.


As data volumes continue to grow, more and more decisions are based on the intelligence gleaned from the data warehouse using various approaches to data mining. Data mining is loosely defined as any machine-based, algorithmic discovery of hidden information in massive volumes of data. Practically speaking, this means leveraging information repositories for nuggets of information that are not readily obvious from the manual inspection of raw data — even with advanced OLAP and reporting tools.

Since the launch of SAP BW 2.1C SP9, various data mining algorithms — or modeling methods — have been available to SAP BW users including:

  • Decision trees
  • Scoring (including regression)
  • Clustering
  • Association analysis

Glen Leslie

Glen Leslie is a product manager for SAP’s Business Intelligence solution. Originally a data warehousing consultant, Glen has been working with SAP BW since the 1.2B release in a variety of environments.

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.