The mixed load scenario is one use of the Business Intelligence capabilities of SAP NetWeaver. In this scenario, query activity and load/update activity are executed in parallel. Multiple users run queries on data in 10 SD InfoCubes. You can choose from the following size categories for the initial data load:

• 300 million records
• 1000 million records
• 3000 million records

In three phases during high load activity, static operational data is extended with delta data.

The key figure of this benchmark is the number of query navigation steps/hour.

The BI mixed load benchmark can be run with or without BI Accelerator.

Benchmark Results

BI-MXL Internet configuration, SAP NetWeaver Release 2004s, with BI Accelerator

BI-MXL Internet configuration, SAP NetWeaver Release 2004s, without BI Accelerator

Note: In the BI-MXL benchmark, both queries and data upload/updates are executed simultaneously. Therefore, BI-MXL results cannot be compared with the results of the BI data mart benchmark or the query phase of the BW benchmark.

Procedure

The following actions are simulated in an SD InfoCube. Three times during the benchmark run (total 1 hour), a delta data package is uploaded. The total size of these packages is 1/1000th of the total records of the initial load

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: Start a new query that retrieves the yearly and quarterly sales volumes for different types of ranges, e.g. sales organizations
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