The Project System (PS) Benchmark consists of the following transactions:
- Create a project using a project profile. (transaction CJ01)
- Execute the cost planning for the project. (CJ40)
- Approve the project. (CJ02)
- Plan the budget necessary for the project. (CJ30)
- Start a report on cost evaluations. (CJ62)
In the Warehouse Management (WM) Benchmark, a transfer requirement (transaction LB01) is created to put three materials into stock. This transfer requirement is used to create a transfer order (LT04). Because the number of items per material in the transfer requirement exceeds the number that can be placed into one storage location, the transfer order has seven line items. The process continues to confirm this transfer order for seven items (LT12). For goods removal, these transactions are called again in the same sequence.
The SAP BW Enhanced Mixed Load Benchmark (BW-EML Benchmark) meets the current demands of typical business warehouse customers. These demands are mainly coined by three major requirements:
- Near real-time reporting – Getting instant results from analytical applications on last minute data nowadays is crucial for timely decision making. Typical examples for real-time data analysis include smart metering or trade promotion management.
- Ad-hoc reporting capabilities – During the last few years, data volumes in data warehouses have dramatically grown. One reason for this growth is the increased complexity and detail level of the data, which in turn requires much more sophisticated and complex analysis methods. As a result, analytical applications are supposed to facilitate navigating through huge amounts of data by providing extensive slicing and dicing functionality. This makes it inherently difficult to foresee frequent navigation patterns and pre-calculate intermediate results to speed up reporting performance. Ad-hoc type query capabilities are required to satisfy these demands.
- Reduction of TCO – Typical sizes of today's data warehouses comprise tens or hundreds of terabytes of data. It is therefore crucial to keep data redundancy at a low level, but still be able to maintain layered data models. SAP NetWeaver BW 7.30 helps reduce the total cost of ownership by allowing reports to run directly on DataStore objects which are the core building elements of a layered warehousing architecture, often eliminating the need to maintain data redundantly in multi-dimensional InfoCube data structures.
The latest addition to the family of SAP BW Application Benchmarks – the BW-EML Benchmark – has been developed with these three customer requirements in mind.
Like its predecessor the BW-MXL Benchmark, the EML Benchmark focuses on a mix of multi user reporting load and delta data that is loaded into the database simultaneously to the queries.