GRC
HR
SCM
CRM
BI


Blog

 

Free Test Tool Checks for Data Problems

by Andrea Haynes

May 3, 2011

Witold Drozdzynski desribes how to populate existing Excel documents with fresh data from SAP NetWeaver BW in his BI Expert article How to Update Existing Excel Documents with SAP NetWeaver BW Report Data.” His method uses multi-dimensional expressions (MDX), Apache POI library, SAP Java Connector (SAP JCo), and ABAP. The use of MDX allows you to reuse InfoCubes and queries in the SAP NetWeaver BW system.

Tip! To ensure the application was running properly, he used the free Apache log4j logging library. The system automatically records all problems with writing the data to destination Excel documents into the log file. The information in the log file helps you identify problems and the time at which the problem occurred.

 

An email has been sent to:






More from SAPinsider



COMMENTS

Please log in to post a comment.

No comments have been submitted on this article. Be the first to comment!


SAPinsider
FAQ