This dialog is used when you want to add a data table where data is loaded only when requested. You can specify what input to control the loading in a number of different ways.
To reach the On-Demand Settings dialog:
Select File > Add Data Tables....
Add the data tables of interest.
Click on the information link or data table from a data connection holding the desired data to select it in the list.
Select the Load on demand check box.
Click on Settings....
Tip: You can change the settings for on-demand loading after a data table has been added to the analysis using the Settings-button in the Data Table Properties dialog.
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 TIBCO 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. |