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 information link. All columns and parameters available in the selected information link 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 information link 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 information link data are 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. |
See also:
How to Insert Multiple Data Tables into the Analysis
,
in the visualization title bar.