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.