Child pages
  • Report SAP_ANALYZE_ALL_INFOCUBES - Create DB Statistics for all Infocubes
Skip to end of metadata
Go to start of metadata

Purpose

The purpose of this page is to clarify the understanding of the program SAP_ANALYZE_ALL_INFOCUBES.

Overview

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.  

Parameters

  • Percentage

Related Content

Related SAP Notes/KBAs

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