The purpose of this page is to clarify the understanding of the program SAP_ANALYZE_ALL_INFOCUBES.
Report SAP_ANALYZE_ALL_INFOCUBES is designed to create db statistics for all infocubes by choosing a percentage relevant to build db statistics. The program is not required for all database platform like MSSQL.
How to use it?
Call transaction SE38 with program SAP_ANALYZE_ALL_INFOCUBES.
Notes describing and correcting program SAP_ANALYZE_ALL_INFOCUBES are below:
618868 FAQ: Oracle performance
1839861 Cannot create infocube statistics from "Performance" tab
1705026 Basic requirements to solve BW performance issues on Oracle
374502 DB6: DB2 UDB - BW Performance - Overview of notes
428212 Using BRCONNECT to update InfoCube statistics
583604 DB6: Regular updates of database statistics of BW tables
797667 Performance problems in BW system require update statistics
421795 Report SAP_ANALYZE_ALL_INFOCUBES
524341 Updating the statistics for individual partitions
726237 Perform data upload & Update Statistic run at different time