How to Use APD to Extract and Transform High-Volume Data from SAP NetWeaver BW

  • by Dinesh Nakka, Senior Enterprise Architect
  • November 4, 2010
In addition to its traditional use for data mining purposes, you can also use Analysis Process Designer (APD) for data extraction when you have large amounts of data and complex queries. Find out how one company set up this process.

At my company, we had a specific business requirement for which we had to provide two years of pricing data — which includes different prices of our products such as list price, base model price multiplier, net price, and attributes of product and customer. We wanted to place the data into our pricing vendor system for further analysis to identify pricing opportunities. We were struggling to decide what might be the best way to extract a million records out of SAP NetWeaver BW into a file.

Our pricing system had specific requirements for the data file:

  • It could only accept a .CSV file
  • All number fields had to be zeroes if they had no values
  • All character fields should have N/A if they had no values
  • The date formats should be dd-mm-yy
  • Numeric values should have the appropriate sign (e.g., -7.34 instead of 7.34-)

Dinesh Nakka

Dinesh Nakka is a senior enterprise architect and project manager specializing in SAP NetWeaver BW, SAP NetWeaver Master Data Management, and SAP ERP implementations. He has more than 12 years of diverse SAP experience in managing and delivering SAP projects in manufacturing, professional managed services, pharmaceutical, and financial industries at Fortune 500 clientele.

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.