SAP Knowledge Base Article - Public

2875492 - How to record RSDDSTAT_OLAP when scheduling Analysis Workbooks in BI platform

Symptom

It is necessary to record statistics in RSDDSTAT_OLAP table when scheduling Analysis Workbooks in BI platform.

Environment

Analysis for Microsoft Office

Reproducing the Issue

  1. Schedule an Analysis Workbook that contains BW data source in BI Launchpad/CMC;
  2. Confirm that no statistics are recorded in RSDDSTAT_OLAP table.

Cause

The profiling trace is not activated.

Resolution

Activate the profiling trace by changing the setting "Profiling" to TRUE in "AO_BiPrecalculation.config" file that should be located in the folder where AO BIP ADD-On is installed.

By default, the setting looks like below:
---------------
<Profiling />
---------------

Change it to:
---------------
<Profiling value="True" />
---------------

See Also

2083067 - How to maintain settings for Analysis Office 2.x

Keywords

broadcasting, broadcast, schedule, scheduling, statistics, RSDDSTAT_OLAP, usage, tracking, records, precalculate, precalculating, scheduled , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions