Make your own free website on

SAP BW (Business Warehouse) Hints and Tips

Please refer to the new site :-

The Business Information Warehouse (BW) is an enterprise-wide information hub. It enables you to analyze data from R/3 applications or any other business application, including external data sources such as databases and the Internet. The SAP Business Information Warehouse also offers easy integration with other New Dimension products, such as the SAP Advanced Planner and Optimizer (SAP APO), the SAP Business to Business (SAP B2B), and the SAP Strategic Enterprise Management (SAP SEM). Additionally, the Business Information Warehouse is a core element of SAPís MySAP.comís reporting strategy. 

The Business Information Warehouse is a comprehensive end-to-end data warehouse solution with optimized structures for reporting and analysis. To help knowledge workers quickly ďmineĒ the business data in an enterprise, BW is equipped with preconfigured information models and reports, as well as automatic data extraction and loading methods. With an easy-to-use Microsoft Excel based user interface, you can create, format, and analyze reports. Built for high performance, the Business Information Warehouse resides on its own dedicated server. Online Transaction Processing (OLTP) and reporting activities are therefore separated, and system performance is not compromised.

Table of Contents
SAP Business Information Warehouse
The benefits of SAP BW

Suggestions for Automating Loads
Removing Excel Macros After Saving as Excel Workbook
Delta Update for Generic Data Sources
Reporting capabilities of SAP BIW
Loading Transactional Data
Customizing for extraction
Standard Infocubes for SD
Invalid source system name entered