This dialog is used to edit settings for a data table which has been specified to load data on demand.
To edit on-demand settings:
Tip: By editing the on-demand settings you can switch off on-demand all together and instead get all data at once.
On the authoring bar, click
Data canvas 
.
Make sure the data table of interest is selected.
Comment: This step is only applicable if you have two or more data tables in the analysis.
In the graphical structure, click on the data source node you want to edit.
In the list to the lower left,
click the menu on the loaded data step and select On-demand
settings 
.
Comment: You can also change the on-demand settings using the Settings-button in the Data Table Properties dialog.
Option |
Description |
All
data at once |
Click this radio button to switch off the on-demand loading and instead load all data immediately. |
Data
on demand |
Click this radio button to load data on demand only. If this option is selected you must specify what parameters will be used to control the on-demand loading. |
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 specify how the selected parameter will be connected to the on-demand data. |
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. |
,
on the visualization title bar.