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
- Schedule an Analysis Workbook that contains BW data source in BI Launchpad/CMC;
- 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