Set Up a Data Input Interaction

This applies to: Managed Dashboards, Managed Reports

A data input interaction lets viewers of dashboards or other views append data to the Data Input transform in a data cube. This article walks through an example of how you can set up this type of interaction.

Data can be entered by a viewer through a variety of input controls available, which can be combined together into a form for users to fill out. It can also come from an interaction with existing data or from script by using a view parameter.

Note: This interaction can't be added directly to a data visualization.

Create a Data Cube

First, create a simple data cube using the Data Input transform.

Add three data input columns:

• Textbox (containing the String data type)

• Number (containing the Integer data type)

• DropDown (containing the String data type)

Create a Dashboard

We can create a simple user input form on a dashboard to append data to these columns.

From the toolbar, add a Textbox filter:

• Change the label text (Textbox in this example).

• Enable the Manual Items property.

• Select to enable Hide Token Menu for this filter.

Add a Single Number filter:

• Change the label text to Number.

• Enable the Manual Items property.

• Select to enable Hide Token Menu for this filter.

Add a Drop Down List component:

• Adjust the Options list to include Item 1, Item 2, and Item 3.

• Set the Value of each item to be the same as the caption.

• Add a label component with the text Drop Down above.

Add a Button component and change the button text to Data Input.

Set Up an Interaction

With the button selected, click Set Up Interactions from the toolbar and select Data Input.

In the Set Up Data Input dialog, enable Clear Input Sources and select the prepared data cube.

For each column in the Data Input transform in the cube, choose an input source. These can be either an input control such as a textbox, or a view parameter.

For our example, set up the following mappings given the default names identifying our input controls:

• Textbox – parameterTextBox 1

• Number – parameterNumeric 1

• Dropdown – dropDownList 1

Select Save.

Test the Interaction

Switch to View mode, fill out the form, and click the button.

Then, go to the data cube and open the Data Preview panel to verify the input data.

• The appended data is always a single value. In the case of a range or collection, the input is the beginning or first value respectively.
• Users require the Data Input privilege to be able to input data.

For more information, see:

• Data Input

• Set Up a Data Input Interaction

• Using Interactions

• Application Privileges