Abstract:The purpose of this paper is to demonstrate the capabilities of three solutions to optimize and increase performance of SAP NetWeaver BW performance on IBM i, namely: SAP BW aggregates, DB2 for IBM i Materialized Query Tables (MQTs) and the SAP BW Accelerator (BWA). Using a workload similar to the SAP MXL benchmark, all three solutions were implemented, tested and performance results compared.