Update Statistics for InfoCube Tables

Use

The InfoCube tables used in SAP Business Information Warehouse (SAP BW) and Advanced Planner and Optimizer (APO) need to be processed in a special way when the statistics are being updated. Usually, statistics should be created using histograms, as described in SAP Note 129252.

Statistics for the InfoCube tables can be updated, together with other tables in a run. In this case, the statistics for the InfoCube tables are always created with histograms. You can specify which tables are to be handled as InfoCube tables using the init<DBSID>.sap parameter stats_info_cubes. However, this is normally not needed.

Prerequisites

The control table RSNSPACE for Business Information Warehouse (BW) and Advanced Planner and Optimizer (APO) dynamically determines which tables are to be handled as InfoCube tables. The content of the control table might change in future.

Features

By default, tables with names starting with the following prefixes are processed by BRCONNECT as InfoCube tables:

/BIC/F*, /BIC/A9F*,

/BI0/F*, /BI0/A9F*,

/BIC/E*, /BIC/A9E*,

/BI0/E*, /BI0/A9E*,

/BIC/D*, /BIC/A9D*,

/BI0/D*, /BI0/A9D*,

/BIC/S*, /BIC/A9S*,

/BI0/S*, /BI0/A9S*,

/BIC/X*, /BIC/A9X*,

/BI0/X*, /BI0/A9X*,

/BIC/Y*, /BIC/A9Y*,

/BI0/Y*, /BI0/A9Y*,

/BIC/I*, /BIC/A9I*,

/BI0/I*, /BI0/A9I*,

/BIC/P*, /BIC/A9P*,

/BI0/P*, /BI0/A9P*,

/BIC/Q*, /BIC/A9Q*,

/BI0/Q*, /BI0/A9Q*

The above list provides the default value of the init<DBSID>.sap parameter stats_info_cubes, that you can use to include the following kinds of tables in the list of InfoCube tables:

·        Groups with names starting with a certain prefix

·        Individual tables in the list of InfoCube tables

To include the above default list, specify the keyword DEFAULT in the first position, as in the following example:

stats_info_cubes = (DEFAULT, XYZ*)

To suppress special handling of the InfoCube tables completely, use the keyword NULL:

stats_info_cubes = NULL

If certain prefixes are omitted in the parameter definition, the corresponding tables are not to be handled as InfoCube tables.

However, we do not recommend you to do this. Normally you do not need to set the parameter at all.

For additional, special handling of InfoCube tables, you can use the keyword INFO_CUBES for the following:

·        BRCONNECT with the -f stats function using the -t|-table and -e|-exclude options

·        init<DBSID>.sap parameters:

Ў        stats_table       

Ў        stats_exclude     

Ў        stats_dbms_stats

The function of this keyword is to ensure that only InfoCube tables are processed in accordance with the selected parameter settings.

Examples

·        brconnect -u / -c -f stats -t info_cubes

Statistics are only checked for InfoCube tables and updated, if required

·        brconnect -u / -c -f stats -t all -e info_cubes

Statistics are checked for all tables besides InfoCube tables and updated, if necessary.

·        stats_dbms_stats = INFO_CUBES:R:4
brconnect -u / -c -f stats -t all

Statistics are checked for all tables and updated, if necessary. New statistics for InfoCube tables are created with the DBMS_STATS package using row sampling and an internal parallel degree of 4.

For more information, see stats_dbms_stats.

·        brconnect -u / -c -f all

This is the default. Statistics are checked for all tables and updated, if necessary. If InfoCube tables are present and selected following the update check, statistics are generated for them using histograms.