Re-wire the data flow

Contents[Hide]

1. Overview

Learn how to adjust Dundas BI elements to changes in the structure of your data. This allows you, for example, to migrate to a new database without having to rebuild the dashboards.

The following examples show you how to:

  • Replace a data cube select transform with another.
  • Edit the input elements of a data cube select transform.
  • Re-wire metric set elements to a different source data cube.

The examples rely on the data cube created by following the instructions in Using a data cube to join tables, and a custom Excel data connector. For simplicity, the Excel table Person is a copy of the [Person].[Person] SQL table with the addition of one column, LegalFirstName.

2. Replace a select transform

Open the data cube you would like to rewire. The following steps will replace the [Person].[Person] SQL Select with a prepared Excel table.

Open the data cube
Open the data cube

From the Explore panel, locate the replacement Excel table and drag it over the SQL Select transform.

Drag the replacement table
Drag the replacement table

In the Re-Wire Elements dialog, use the Native Source Element Name drop-downs to match the existing input connectors to the new source elements. 

Match the Connector Name to the new source element
Match the Connector Name to the new source element

Click Submit.

Observe that the SQL Select is replaced with a Tabular Select. The Join and Process Result transforms remain intact, and maintained all of the previously applied settings.

Observe the result
Observe the result

3. Edit the input elements of a select transform

In the above example, you re-wired the data cube to use an Excel table instead of an SQL one. Double-click the new Tabular Select to configure it. Notice the unused column, LegalFirstName, which was meant to be used instead of FirstName.

Scroll down and click Edit input elements.

Click Edit input elements
Click Edit input elements

From the Connector Name column, locate FirstName, and use the Native Source Element Name drop-down to select LegalFirstName.

Select another source element
Select another source element

Click Submit.

Observe that the hierarchy is still named FirstName, while the data comes from the LegalFirstName column.

Observe the result
Observe the result

Note
Some transforms (for example Data Cube and Stored Procedure) do not allow this functionality.

4. Re-wire metric set elements

The following example relies on a copy of the same data cube, built fully from the Excel data connector, as a new source data cube.

Another data cube
Another data cube

Create a metric set using the data cube created in the above example. From the toolbar, select Replace Source Cube.

Create a metric set
Create a metric set

Select the new source data cube and click Submit.

Select the new data cube
Select the new data cube

In the Re-Wire Source Cube dialog, use the Replacement Structure Element Name drop-downs to match the existing elements to the new source elements.

Match the Element Name to the new source element
Match the Element Name to the new source element

 Click Submit.

Observe that the metric set is refreshed and now uses the new source data cube. The applied hierarchies and settings remain intact.

Observe the result
Observe the result

Note
Metric sets containing dynamic elements (measures or hierarchies) do not allow this functionality.

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