This dialog is used when you want to add some data which is loaded only when requested. On-demand loading is available for data connections and information links. You can specify what input to control the loading in a number of different ways.
To add an on-demand data table:
On the authoring bar, click
Files and data 
.
Select the data connection or information link of interest.
In the Add data to analysis summary, click the data you want to add as on-demand data, to show the configuration settings.
From the drop-down list, showing Import or External, select On-demand.
Click Configure.
To edit on-demand settings:
You can edit the on-demand settings from the Data canvas, or by using the Settings-button in the Data Table Properties dialog.
Tip: By editing the on-demand settings you can enable on-demand loading for a data source that previously did not use on demand.
Option |
Description |
Define
input for parameters that should control loading |
This is where you select what will affect the loading of data from the perspective of the on-demand data table. All columns and parameters available in the selected on-demand data table are listed. Click to select the parameter in the list and click Define Input... to specify a condition that must be fulfilled for any data to be loaded. For example, this is where you specify that the marking based on a certain column from one data table will limit what is shown in the on-demand data table. If you would like to retrieve only data for a certain Region as shown in the picture above, you would select Region in this list and click Define Input to specify that only those rows corresponding to the set condition (e.g., marked rows in the data table "Sales Data") should be retrieved. Any required prompts or parameters that were specified upon the creation of the on-demand data table will be listed as Required parameters in this field. This means that you must specify input handling of these parameters to be able to load any on-demand data at all. |
Define
Input... |
Opens the Define Input dialog where you can tie the selected parameter to a value or a range. |
Clear
Input |
Removes the previously added input definition from the selected column or parameter. |
Load
automatically |
Select this check box
if the on-demand data should be loaded automatically each time
the specified input conditions are changed. If the check box is
cleared the visualization can be manually updated using the refresh
icon A data table set to load automatically will switch to manual update if cyclic dependencies are detected in the analysis. |
Allow
caching |
Select this check box to allow caching of data. This may speed up the process when loading new subsets of data. However, if the underlying data is updated during the current Spotfire session you may end up with different results for a specific set of input values depending on whether or not the current selection is stored in the cache. You should always clear the check box if you know that the underlying data may be updated during your current session. Note: This caching is done on the client and it is based entirely on the input values, without any connection to the underlying data. There will never be a query sent to the data source to see if that data has been changed. So, if you have defined input based on the values in a column, data will therefore not be reloaded unless the input has changed since the last time. If you are disabling and enabling this setting again, the existing client cache will be used once again. |
See also:
,
on the visualization title bar.