Benchmark SAP Business Information Warehouse (SAP BW)

The Business Information Warehouse benchmark has been replaced by the Data Mart (BI-D) and Mixed Load (BI-MXL) benchmarks. From January 2008 onwards, no further BW benchmarks will be certifiable.

The SAP Business Information Warehouse (BW) Benchmark consists of two phases - load and query - that run consecutively, as of SAP BW 3.0.



Benchmark Results
Two-tier Internet configuration, SAP BW Releases 3.0B - 3.5

Three-tier Internet configuration, SAP BW Release 3.5

Two-tier Internet configuration, SAP BW Releases 1.2 - 2.0B

Procedure
Step 1 Load Phase - Part 1
In part 1 of the load phase, master data is loaded from an external flat file structure into master data tables, and transactional data is loaded from flat files into the persistent staging area (PSA) and the InfoCube. Next, aggregates are built, and statistics and bitmapped indices on the fact table, as well as the rollup of aggregate, are refreshed.

Key figure Throughput of data in rows/hour

Step 2 Load Phase - Part 2
In part 2 of the load phase, data is loaded from the PSA into the operational data store (ODS), and the ODS is activated.

Key figure Throughput of data in rows/hour

Step 3 Query Phase
In the multi-user query phase, the following actions are simulated in an SD InfoCube.





source: http //www12.sap.com/solutions/benchmark/bw.epx
published: 2008-04-10 20:37:05

Related articles

SAP POINT-OF-SALE SOFTWARE
MULTICHANNEL RETAILING
WAREHOUSE MANAGEMENT SOFTWARE
WM module of SAP R/3
SAP Inventory and Warehouse Management
SAP CRM CUSTOMER-DRIVEN GROWTH
SAP Business Suite Software Applications for Every Business and Every Process
SAP - Enterprise Applications
SAP Solutions making your business A Best - run business
4.0 Building SAP BW into multi-tier architecture model in Business Services