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.
| 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 |
|