(DI-1904) Wizard Setup of the BW Analysis

Owned by SNP
Nov 22, 2018

BW wizard installs all the settings, which are necessary to run the Fiori and SAP GUI analyses. Please note that only an Insights administrator should run the wizard.

To run the BW wizard enter the transaction /DVD/HS_WIZ or the transaction /DVD/MON and in the menu select Goto > BW analysis wizard.

  1. Wizard contains several steps; the first is an introductory screen.

  2. The System ID is filled with the system name, in which the BW analysis will be configured.

    The field is automatically filled with the current central system. If you want to configure the BW analysis on another system, just type the name of the system in this field (or press key F4). The selected system must have a valid RFC destination.

    You can configure only one system at a time. If you need to configure more systems, repeat the steps for every system.

  3. To obtain relevant information about the usage of your BW system, activate the OLAP statistics and the Extended query statistics. The Datavard Extended query statistics help you to capture even more detailed information about executions of queries on your BW system.

  4. The wizard marks the fields and hence automatically activates the OLAP statistics.

    Make sure you have set the OLAP Detail Level 2 for the objects (queries and InfoProviders) for which you would like to run the query analysis. You can perform this through the transaction RSDDSTAT on the system you selected in the first step.

  5. If you are using a different language than English for query descriptions, you may change it to a language of your choice in the next screen. This setting is used globally for all analyzed systems.


    displays the current split characteristic of an InfoProvider and enables you to change it to the most suitable one.

enables you to add additional time characteristics.

To obtain relevant results of Data distribution analysis a split characteristic should be identified by most of the InfoProviders (at least by those that are interesting for you). Based on this split characteristic data is split into year partitions.
To find out the number of identified split characteristics may be a time-consuming action, therefore  displays the most recent statistics.

Confirm the next pop-up.

5. A collector regularly collects analyzed data from a satellite system and transfers them to central system. Data is than processed by front end applications which display results.

If you are scheduling BW collectors on the selected system for the first time, you should schedule their first execution at least 1 week after you turn on the Extended query statistics. This is important for Data distribution analysis, as the analysis identifies the split characteristic (the most used time characteristic) of the InfoProviders based on these statistics.


6. Last step is to confirm the setup with .

7. After clicking you can see setup summary. Please review the execution logs. If the logs contain an error, please view the long text.
In the case of an error, you may repeat the setup of the system.