Load wInsight Analytics Data

Before you can begin using the wInsight Analytics module, you must load the initial set of data that you want to make available for analysis. After you begin using the wInsight Analytics module, you can update the data as often as necessary.

Prerequisites:

Before you load a set of data, use wInsight Analytics Configuration to specify the configuration settings you want.

After you make all the configuration entries, make sure that you click Save Settings for wInsight Analytics and that you also click on the QlikView toolbar to save your entries in QlikView.

Note: If you make any changes to the configuration settings, it is very important that you both click Save Settings for wInsight Analytics and click on the toolbar to save the current configuration settings before you run the data load process. If you do not do both, the data load may not use the most current configuration settings.

If you want to load views and user-defined filters, copy the current WSCUSTOM.xml file from wInsight to the <wInsight Analytics module installation location>\Setup folder. If you load new or updated filters, make sure that you set the options in wInsight Analytics Configuration so that data is reloaded for all months for which you want to use those filters.

To load data using the Load_wInsight_Data.bat file, complete the following steps:

  1. On the server or standalone computer on which you installed the wInsight Analytics module, log on as the DeltekAnalytics user or as another QlikView-licensed user that you have set up. Do not log on as the DeltekAnalyticsCW user to run this batch file.
  2. Go to the <installation location>/Admin folder.
  3. Run the Load_wInsight_Data.bat file. This process takes some time; how long it takes depends on the size of your database and how many periods you are loading. When it is completed, a message displays that confirms that the data model has been updated with the current wInsight Analytics data, based on your configuration settings.
  4. If you loaded new or updated views, do the following:
    1. Open wInsight_Analytics.qvw in QlikView Desktop.
    2. Click File > Reload.
    3. Save the file.
    4. Repeat steps a – c for wInsight_Analytics_MutliProject.qvw.
    This step is not necessary in order to update user-defined filters. It is only required for views.
Parent topic: Data Load