Speed Up Your InfoCube Loads and MultiProvider Reporting
- by Joerg Boeke, Independent BW Senior Consultant and Solution Architect
- May 1, 2008
Use time-based and logical partitioning to improve query and load performance for InfoProviders with SAP settings in SAP BW 3.x and SAP NetWeaver BI 7.0.
Partitioning data enables you to distribute it across several tables. This helps improve query performance and makes database administration less complicated because it prevents tables from growing too large. Time-based partitioning sorts data based on the 0CALMONTH, 0FISCPER, or 0FISCVARNT attributes. Logical partitioning can be either heterogeneous (different InfoProviders with different structures) or homogenous (identical InfoProviders with different structures).
Perhaps you implemented your SAP NetWeaver BI data warehouse yourself and you’re pretty confident about what’s going on when you upload data to it. Or maybe your consulting partner provides clear, concise, and complete documentation. Even so, you may need more information to optimize your data warehouse. For example, SAP has developed recent enhancements to the upload process. Also, SAP NetWeaver BI contains features that have been available since the early versions of SAP BW but haven’t been fully communicated to the user base. Still other features came into your environment with various Service Packages.
Partitioning is one hidden feature that you can use to help speed up and simplify your data setup. When coupled with tuning performance, partitioning in a MultiProvider can boost performance when you’re running existing reports. I’ll introduce you to the two partitioning methods you can use with SAP NetWeaver BI and SAP BW: time-based partitioning and logical partitioning (i.e., partitioning InfoCubes logically by characteristics). For a refresher on partitioning basics, see the sidebar at the end of this article.
Would you like to see this full item?