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.

Key figure: Number of query navigation steps/hour

1. Query 1: Select a year	7. Start new query including formulas
2. Within the year, drill down to a specific country	8. Query 2: Perform an ODS query limited to customer, distribution channel, sales organization
3. Within the country, drill down to a specific sales organization	9. Query 3: Similar to query 1 for country, sales organization, and distribution channel
4. Within the sales organization, drill down to distribution channel	10. Within this query, expand to material level two
5. Within the distribution channel, drill down to type, version, and material number	11. Expand to level three
6. Change material number and customer number