Defining Data: Defining Auto Updating Properties

If you are creating or modifying an Analysis Configuration, you can specify options for automatically updating the data file (spreadsheet) and dependent analysis.

Enable transfer

Select the Enable transfer check box to allow the updating of analyses/charts with the new data collected. Leaving this option selected (as is default) enables the other options. More importantly, selecting Enable transfer places two icons/controls within a toolbar on the Analysis Configuration's spreadsheet titled appropriately, "Update Analysis data now" and "Suspend/Resume auto update of Analysis data."  These provide interactive control for the users regarding updates to their data. Clearing this check box prevents all update capabilities for the Analysis Configuration.

Automatically update every

If this check box is selected, you can specify the time interval between automatic updates. Automatic transfer does not exclude the ability to manually update data via the Update Analysis data now control on the spreadsheet. Deactivation of automatic data update with the Suspend/Resume auto update of Analysis data control is also possible.

Display warning when update fails

Automatic updating will sometimes fail, simply because SQL queries sometimes fail. If you want the user to be notified when an update fails, select the Display warning when update fails check box. An example scenario in which this option might be selected is when updates are relatively infrequent (e.g., every 10 minutes). If the query for updating fails, it would be useful for the user to know so that another query can be initiated without waiting an additional ten minutes to fetch the latest data.

Always recreate data file

Select this check box to refresh the entire query with every update. Unless this option is selected, only data that have been added since the last update will be retrieved when the query is refreshed. When historical data (i.e., data previous to the last time the query was refreshed) may have changed or when the query involves an aggregate function, select this check box.

When updated, run the following secondary SVB program

The options in this group box are used to specify whether to run an SVB script at each update.

None

Select this option button to not run a secondary SVB program when the data is updated.

Local SVB File

Select this option button to run a file based secondary SVB program. Click the Browse button to display the standard Open file dialog box to select the file to be automatically updated. Note that all users running this Analysis Configuration will need read access to the file through the file path exactly defined.

Stored-in database secondary code

Select this option button to run the SVB program that has been stored in the Statistica Enterprise database.

When updated, run the primary SVB program (click Next to edit).

Cancel

Click the Cancel button to close the dialog box. Any changes made will be disregarded.

Back

Click the Back button to return to the Defining Data dialog box.

Next

Click the Next button to continue to the Defining Properties (SVB Report) dialog box.

Finish

Click the Finish button to accept selected options and close the dialog box.