Data Input

Contents[Hide]

The Data Input transform lets you reference a warehouse data storage area containing user input data. 

You can use the Data Input transform to add and modify data from inside Dundas BI.

1. Input

Input into the Data Input transform is done manually after the transform has been configured. It does not require another transform for input and generates output based on user-provided data.

2. Add the transform

When creating a new data cube, you can add the Data Input transform to an empty canvas from the toolbar.

Add the Data Input transform from the toolbar
Add the Data Input transform from the toolbar

The Data Input transform is added to the data cube and connected to a Process Result transform automatically.

The Data Input transform is added
The Data Input transform is added

You can also add the Data Input transform from the toolbar to an existing data cube process. A typical example is to connect the Data Input transform to a Union transform that merges data from multiple inputs.

Merging Data Input output with other data using a Union transform
Merging Data Input output with other data using a Union transform

3. Configure the transform

Double click the Data Input transform or select the Configure option from its right-click menu.

The Data Input transform has six automatically created and populated columns. By default, these columns are not selected to be included in the output:

  • RecordID
  • RecordSequence
  • CreatedBy
  • CreatedTime
  • LastModifiedBy
  • LastModifiedTime

In the configuration dialog for the transform, the key task is to add the required columns. Click Add Column and complete the Data Input Column dialog.

Configure the transform by adding the required columns
Configure the transform by adding the required columns

4. Output

The output of the Data Input transform is a Select of the user input data.

Select the Data Input transform and open the Data Preview panel. Type data into the text field to input data.

Right-click a cell to insert an additional row or create a new column.

Insert rows and create columns using the context menu
Insert rows and create columns using the context menu
 

5. Notes

  • Deleting a column from the Data Input transform is postponed until after you check in. This means you will be unable to create a column with the same title as the deleted one until you check in and check out the transform.

6. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri