There are additional prerequisites for enabling BW analysis depending on the system type:
Central system prerequisites:
- SAP_BASIS and SAP_BW components installed.
Satellite system prerequisites:
- 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.
User authorization
For proper initial setup user need to have access to following transactions: SE16, RSRT, SLG1 which are not included in administrator authorization role /DVD/MON_ADMIN.
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.
| Step | Details |
|---|---|
Go to transaction /DVD/QS_CONF | |
Screen for setting up configuration is displayed. |
Insights Extended Query statistics configuration screen |
Click on 'ON' radio button for 'Query statistics enabled' to turn collection of statistics on. User information collected can be turned on optionally (If this setting is turned on information about which user executed query is captured). | |
| Confirm change of configuration by clicking on 'Save config' button (or using F8 key). | |
| Confirmation dialog is displayed. |
Change configuration confirmation dialog |
| Click on 'Yes' button to confirm change of configuration. |
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 user 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 for specific 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.
Restrict query statistics collection
Click on "Exclude characteristics" button to display select option for characteristics exclusion. In this window user can define which characteristic filter values should not be saved when queries are executed. This option should be used only when necessary to reduce amount of data saved in statistics table (useful for huge hierarchy selections) as it reduces completeness of statistics.
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' (transaction /DVD/QS_SCHED) is provided. You can create two standard report variants for this report.
Scheduling of DVD extended query statistics collection
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:
- Go to transaction RSRT and choose random Query with filtering options.
- Click on 'Execute + Debug' button to display query execution options.
- In the list of settings mark checkbox next to 'Do Not Use Cache' option.
Do not use cache query execution option
4. Click on Continue (or use Enter Key) to execute the query (in next screen that is query dependent fill at least one filter).
5. Go to transaction SE16.
6. Insert following table name '/DVD/QS_QINFO' and click on 'Table contents' button (F7).
DVD extended query statistics main table
7. Do not use any filters and click on 'Execute' button (F8).
8. In following screen with table content you should see at least one row with information about the query just executed through RSRT transaction.
Captured information about executed query
9. Go back to transaction SE16. Fill table name '/DVD/QS_QVAR' and click on 'Table contents' button (F7).
DVD extended query statistics filter table
10. Do not use any filters and click on 'Execute' button (F8).
11. In following screen with table content you should see at least one row with information about used filter in executed query (if you chose such query with filters and specified some).
Captured filtering information
If any information is captured after DVD statistics were enabled in system and query was executed validation is done.