Setting up data input

1. Overview

Dundas BI includes the ability to add and modify data within the application, and to store it in its warehouse data storage area. This data can then be used as a data source.

Since you are inputting the data and it is stored in the Dundas BI warehouse, you do not need to use a data connector for this functionality. Other than the lack of an explicit data connector, data input follows the usual Dundas BI Data Model that relies on data cubes and metric sets to display data on dashboards, reports, and scorecards.

If you indicate a Default Value, that value will be automatically populated in that column for each new row.

The Data Input Column dialog is replaced with a single-column table on the Data Preview window. Type data into the cells to input data. Type ENTER to create or move to the next row, and TAB to create or move to the next cell to the right.

Right-click to insert a row or create a new column, or move the mouse and click the + icon when it appears where you want to add a row or column.

The Data Input Column dialog is replaced with a single-column table on the Data Preview window. Type data into the cells to input data. Type ENTER to create or move to the next row, and TAB to create or move to the next cell to the right.

Right-click to insert a row or create a new column, or move the mouse and click the + icon when it appears where you want to add a row or column.

5. Modify input data

No matter where you initially set up data input, when working with this data you can access the editable table again to make changes. To modify input data, open the Data Preview window, and click Modify Data.

6. Pasting data

If you have existing data in another application, you can copy multiple values into the data input table.

Copy (Ctrl+C on your keyboard) some columns and rows of data from the other application, then click a cell in Dundas BI's Data Preview window and paste (Ctrl+V on your keyboard).

The pasting action works from left to right and from the top down, which means the cell you selected should correspond to the top-left cell of your pasted data. If that cell does not exist yet, you can quickly add a new line by hovering over the last cell and clicking the green plus.

Pasting values from more columns than those set up for data input will not create new columns.

To delete multiple rows, select the rows by clicking the numbers on the left while holding CTRL or SHIFT on your keyboard to select individual rows or a range of rows, respectively. Right-click the table when rows are selected and click Delete Selected Rows.