Business Information Warehouse (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.

Key figure: Number of query navigation steps/hour

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