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.
Key Concept

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.

Joerg Boeke

Joerg Boeke is an independent SAP NetWeaver BW solution architect and senior consultant with 12 years experience in SAP NetWeaver BW, having worked on it since SAP BW 1.2A. He offers significant expertise in the SAP NetWeaver BW reporting area, including design, data integration, data visualization, performance optimization, and the cleanup of existing SAP NetWeaver BW systems. He is the author of SAP BW 7.x Reporting - Visualize your data.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.