...

• SAP BW release: 7.00 - 7.50
• SAP_BASIS and SAP_BW components installed.
• Turned on collection of standard OLAP statistics in system. 
• Turned on collection of DVD statistics in the system (recommendation is to collect statistics at least for two weeks before first collectors are executed). See bellow section for more details.
• In case you are using ORACLE DB as your system database you need to make sure DB statistics are up to date on all tables required by collectors else these will be not executed.

DVD extended query statistics setup

Turning on/off collection of statistics

After successful import of transport with DVD extended query statistics collection can be turned on/off by completing following steps.

...

8. Same steps apply also for turning off the statistics. To turn collection of statistics off only difference is to click on 'OFF' radio button in step 4.

Additional collection options

Click on 'Select infoproviders' button. Dialog window is displayed where use can restrict for which InfoProviders should be statistics collected. If no InfoProviders are specified in table (initial state) statistics will be collected for whole system. You can always disable collecting of statistics forspecific InfoProvider by deselecting 'Enabled' column or removing them from the list. It is important to note that once the Infoprovider selection is used statistics will be collected only for those with "Enabled" flag one. For not specified Infoproviders in the list statistics will not be collected.

...

_{Excluding characteristics from collection}

Scheduling of statistics collection

It is possible to schedule enabling of statistics on regular basis if requested. For this purpose report '/DVD/QS_CONFIG_SCHEDUL' is provided. You can create two standard report variants for this report. 

...

In first variant you specify checkbox as marked while in second variant this checkbox would be unmarked. You can then schedule execution of this report with first variant every morning through standard SAP report scheduling functionality. This would cause statistics collection to be turned on every morning. Then you would schedule execution of this report with second variant every midnight to turn off the statistics collection.

Validating collection of DVD extended query statistics

After the statistics are enabled in a system by using steps specified in Turning on/off collection of statistics section it is recommended to validate their functionality. To validate follow the following steps:

...