QlikView Refresh Utility

The QlikView Refresh Utility is executed outside the Millennium interface. From the specific machine on which the QlikView Server is installed, use the Windows Explorer to navigate to QlikViewRefresh.exe.

The purpose of the QlikView Refresh Utility is to keep your Visual Analyzer documents up-to-date. It does so by reloading the data into the documents. Reloading the data 'refreshes' the documents with live Millennium data. Remember that the data that is stored with each Visual Analyzer document is static. Any changes that are made to the live Millennium data after the QlikView Refresh Utility is executed will not be reflected in any Visual Analyzer document until the QlikView Refresh Utility is executed again. Most sites will want to execute the refresh utility at least one time a day in order for Visual Analyzer users to have the most current data available. The utility includes an option to run in an unattended mode so that you may schedule it to run 'after hours'.

Important! Community Brands very strongly recommends that the QlikView Refresh Utility be scheduled to run after midnight. This will avoid the situation where you might, at the end of the month, refresh the data with a previous month's data, and then view it in the following month.

During the Visual Analyzer set up process, the QlikView Refresh Utility is installed on the QlikView server machine. The utility must be run from the QlikView server, by a User ID with full rights to the Millennium database. The QlikView server must have an ODBC connection to the Millennium database. The utility can be run in either interactive or unattended mode.

Behind the scenes, the refresh utility will launch Qv.exe. Qv.exe is a QlikView program that was installed on the machine when the QlikView Server was installed. Qv.exe will remove all copies of the Visual Analyzer documents for each QlikView Group, recopy the Visual Analyzer documents for each of the QlikView Groups, and then reload the Millennium data into these new copies.

The utility generates a log file; it is named QlikViewRefresh.log and it is located in the same directory as the utility. The log file is overwritten each time the utility executes. Once the refresh utility completes, the log file should be checked for messages.

Utility Classification

This utility is classified as a system administrator tool for performing system maintenance.

Utility Requirements

• The utility must be installed on and run from the QlikView Server machine.
• The QlikView Server must have an ODBC connection to the Millennium database. If the utility will be executed in an unattended mode, the ODBC DSN name must be Web SQL.
• The utility must be run by a user name with full rights to the Millennium database.
• All Millennium users must be out of all Visual Analyzer documents.

Use the QlikView Refresh Utility in Interactive Mode

1. Ensure that all users are out of the Visual Analyzer documents.
2. Navigate to the location of the utility program - QlikViewRefresh.exe - and double-click to launch.
3. Click the text box to browse to the location of Qv.exe.
4. Click Start.
5. Click the Machine Data Source tab and select Web SQL (or the data source name you supplied when creating the ODBC connection to the Millennium database) from the list of available Data Source Names.
6. Log on as a user with full rights to the database; for example, sa for SQL Server, MILLORA for Oracle, or millennium_admin. Click OK.
7. Descriptive messages will display above the Start button to keep you informed of the refresh utility's progress.
8. The utility will inform you once it completes and remind you to check the log file for any messages. Click OK to clear the message and exit the utility.

Use the QlikView Refresh Utility in Unattended (Silent) Mode

1. Navigate to the location of the utility program - QlikViewRefresh.exe - and double-click to launch.
2. Select the Unattended Mode Settings menu item.

3. Enter the user name and password that will be used to log on to the utility. The password will be encrypted before it is saved. Remember that the user must have full rights to the database - a log on of sa or MILLORA (for oracle sites) or millennium_admin is preferred. When executed in unattended mode, Web SQL will be the ODBC Data Source Name that will be used.

   Note: If the password is changed for the user name, the new password must be entered in the Unattended Mode Settings form before the utility can be successfully executed in Unattended Mode again.

4. Click the text box to browse to the location of Qv.exe.
5. Click OK to close the Unattended Mode settings form.
6. Click Exit from the File menu to exit the utility.

7. Set up the application that you will use to launch the utility in unattended mode.

   There are a number of possible techniques for launching the utility in an unattended mode. You might type this expression - QlikViewRefresh.exe /u - into a Command Prompt or into a Windows Start/Run Command, or you might use a third party scheduling software. Whatever technique you choose, in addition to any appropriate navigation or path information required by whatever means that you are using to launch the utility, the file name for the utility must be entered as QlikViewRefresh.exe /u - without the '/u' at the end of the expression, the utility will launch in 'interactive' mode.

8. Once the utility executes, verify that it successfully completed by checking the x:\ProgramData\QlikTech\Documents\ Millennium directory to make sure that the files refreshed.

Top of Page