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.
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.
The Data Input transform is added to the data cube and connected to a Process Result transform automatically.
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.
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:
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.
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.
- 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.