Example of Marking Controlled On-Demand Details Visualization

If you have selected to load data on demand, and specified a marking that should control what data to be loaded you will end up with the following scenario:

When you mark items in a visualization that uses the specified marking, the data for the on-demand data table is updated. The update can either be done automatically each time you change the marking, or manually by clicking on the refresh button displayed when the marking is changed.

This way, you can create a master visualization in which to specify the item of interest and a details visualization where more information about the marked item is loaded from the database only when requested.

To add a marking-controlled on-demand data table:

When one identifier column in the first data table is matched by an identifier column in the on-demand data table, the on-demand data table should be added and configured using the following steps:

1. On the authoring bar, click Files and data .

2. In the Files and data flyout, locate the data source (a data connection or an information link ) of interest by searching for a suitable keyword or by browsing the different categories.

3. When you have selected your data, you will see a summary view showing how the data will be added; the Add data to analysis summary. Click on the new data to enable editing of the settings. Make sure that the new data is added as a new data table, if this is what you want.

4. From the drop-down list, showing Import or External, select On-demand.

5. Click Configure.

   Response: The On-Demand Settings dialog is displayed.

6. In the Define input for parameters that should control loading list, click to select the column in the new data that contains the identifiers.

7. Click Define Input.

   Response: The Define Input dialog is displayed.

8. In the Input for the selected parameter list, select Values from column.

9. Select the Data table used by the master visualization.

10. Select the Column containing identifiers in the master data table.

11. Make sure that the Marked rows check box is selected and that only the check box for the marking used in the main visualization is selected.

12. Click OK to close the Define Input dialog.

13. Use the Load automatically check box to determine whether to reload data as soon as the input conditions change or using a manual update only.

    Comment: This setting can be changed later on in the Data Table Properties dialog or from the Data canvas.

14. Click OK to close the On-Demand Settings dialog.

    Comment:  You might also want to add a relation between the two data tables, so the marked rows from the master data table also become marked in the on-demand data table visualizations. This can be done later from the Data Table Properties dialog. See Data Table Properties - Relations for more information.

15. Click OK.

    Response: The on-demand data table is loaded. The data shown in any visualization based on the on-demand data table will depend on what is marked in the master visualization.

Example of on-demand-loaded data table with manual update:

Click on an item in the master visualization:

The refresh button of the visualization based on the on-demand-loaded data table appears on the title bar. (If nothing was marked from the beginning, the on-demand visualization will be empty until the first refresh.) Click on refresh.

The visualization is updated to show details about the marked item:

Clicking on a different item in the master visualization once again displays the refresh button.

Click refresh to update the on-demand visualization to use the new marking: