SAP NetWeaver BI 7.0: Improve Query Performance and Visibility With BI Statistics
- by Muke Abdelnaby, Principal, Renaissance Partner Group, Inc.
- Hisham Ismail, Principal, Renaissance Partner Group, Inc.
- October 1, 2008
In an SAP NetWeaver BI system, you can experience performance problems and delays when running queries and producing results. SAP NetWeaver BI 7.0’s improved BI Statistics feature makes it easier to diagnose those performance bottlenecks. It generates and stores query runtime statistics you can analyze, and then you can use the SAP NetWeaver functionality to solve the problem.
Query runtime statistics track the parts of system processing critical to performance. Using these statistics, you can determine how much time the system needs to execute certain user actions, which are called events. These events include displaying Web items, building Web pages, generating queries, and saving data. The system determines the runtime of an event by calculating the difference between the start and end times (excluding times for other events called from within the event). SAP NetWeaver BI stores this statistical data in various tables.
A typical challenge for managing an SAP NetWeaver BI environment is to frequently monitor, analyze, and fine tune queries that efficiently produce results for users. SAP has developed new features for companies that have either recently upgraded to or installed SAP NetWeaver BI 7.0, including those that generate and store query runtime statistics you can analyze to uncover performance issues.
The new BI Statistics feature is one of those improvements. Using BI Statistics, you can more effectively collect detailed data, monitor performance, and use analysis tools on key SAP NetWeaver BI objects such as InfoProviders, query retrievals, and data loads.
SAP has improved the method for capturing statistical data on SAP NetWeaver BI queries and warehouse management functions (i.e., various programs and new tables) to provide more accurate and relevant information so that users can better tune their systems. SAP has enhanced InfoProviders and tables that capture detailed statistics on query runtime, data load, and data load status (Table 1). The table lists the relevant SAP NetWeaver BI tables used to store the statistical metrics for the appropriate item, such as process chains. Note that the SAP BW 3.x InfoProvider statistics (such as 0BWTC_C02 and 0BWTC_C03) are not recommended for use. 0BWTC_C02 will not receive any new data because the source table RSDDSTAT is not used for statistics data collection anymore with the new 7.0 BI Statistics. The InfoCube is available but is never populated. 0BWTC_C03 is a bit different. It’s still usable but the new enhancements to the source tables have not been reflected in this InfoCube.
SAP has also stated that it is not possible to transfer your previously collected data into the new SAP NetWeaver BI 7.0 InfoProviders for monitoring or analysis.
Would you like to see this full item?