Performance Tuning for SAP BW: Business Information Warehouse
The performance aspects of a data warehouse project should be of primary consideration, as performance is directly related to the degree of user acceptance of the solution, as well as the overall effectiveness of its analytical capabilities. Every project phase should be reviewed subject to performance: beginning with the data model, through to fine tuning of the database and ending with proactive operational maintenance mode (e.g. review aggregates, build new ones, delete unused ones, find problem queries) as an ongoing cycle. This document gives an overview on all features and settings which impact performance. It also helps to use all tools provided by SAP BW to identify performance problems.