FAQ - BI Accelerator - Performance Figures
- What query performance improvements can be expected?
- How long does it take to build the BI Accelerator index?
- How long does a change run take after changes in master data or hierarchies?
What query performance improvements can be expected?
Using the SAP NetWeaver BI Accelerator, the data read time can be improved significantly. We experienced average improvements by factor 10 to 100; customers have verified this in their BI Accelerator projects.
Note: SAP NetWeaver BI Accelerator does not improve network or frontend time nor has it significant impact on OLAP/calculation time of queries yet. This means that total query response time improvements strongly depend on the query design.
How long does it take to build the BI Accelerator index?
The performance for the index build strongly depends on the underlying data model and the power of the available hardware (parallel). However, as a rough guideline you could assume index build times between 1 and 3 million rows per minute.
For more information, see Rolling Up Data in BI Accelerator Indexes.
How long does a change run take after changes in master data or hierarchies?
Since only master data has to be updated to the BI Accelerator index (no transactional data is touched), the change run is fast. Most customers reported change run times of less than a minute in average.
For information about improving performance after delta loads, see System Response Upon Changes to Data: BI Accelerator Index.