Setting up data input

Contents[Hide]

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.

When you want to input a new set of data, you have three options:

  1. Create a data cube with a Data Input transform. You can then use the data cube to create metric sets, or as a storage area for data input by viewers using a data input interaction.
  2. Create a new metric set based on data that you enter, which will auto-generate a data cube with a Data Input transform. You can then use the metric set in a view such as a dashboard.
  3. Create a new visualization in a view such as a dashboard and enter new data into it, which will auto-generate a metric set and a data cube with a Data Input transform.

2. Setting up data input in a data cube

You can add a Data Input transform directly to a data cube when editing it. For details, see Data Input Transform.

You can add data to this transform yourself, or set up a data input interaction for viewers to add to it.

3. Entering data into a new metric set

On a new metric set, click Enter New Data.

Click Enter New Data when creating a new metric set
Click Enter New Data when creating a new metric set

The Data Preview panel automatically expands to show the Data Input Column dialog. Provide a Column Name and select the Column Data Type, and then click Submit.

Complete the Data Input Column dialog and click submit
Complete the Data Input Column dialog and click submit

Note
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 panel. 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.

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.

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

Like any other metric set, you can now re-visualize and customize this metric set.

4. Entering data when editing a dashboard

When editing a dashboard, add a new data visualization from the toolbar (for example, a Bar chart). 

Open the Data Preview panel and click enter new data.

Click enter new data on the Data Preview panel
Click enter new data on the Data Preview panel

The Data Preview panel automatically expands to show the Data Input Column dialog. Provide a Column Name and select the Column Data Type, and then click Submit.

Complete the Data Input Column dialog and click submit
Complete the Data Input Column dialog and click submit

The Data Input Column dialog is replaced with a single-column table on the Data Preview panel. 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.

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.

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

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 panel, and click Modify Data.

Click Modify Data to change the input
Click Modify Data to change the input

6. Notes

  • Deleting a column from the data input table 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.
  • Changes to rows of data are not affected by check in or check out states, as viewers or end users can be allowed to make changes. Undo Check Out does not change or remove data.

7. 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