Re-wire the data flow

Contents[Hide]

1. Overview

This article shows how to change the data sources and structures used behind existing data cubes and metric sets. 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 data from another data connector.
  • Re-wire a metric set to use data from a different data cube.

These examples make use of the data cubes created in Using a data cube to join tables, and an Excel spreadsheet. For simplicity, the Excel sheet 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 SQL Select with a prepared Excel table.

Open the data cube
Open the data cube

In the Explore window, 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 the submit button at the bottom of the dialog when done.

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

Note
The old element names will still be used, as can be seen in the Process Result node.

2.1. Edit the input elements

You can edit the matching of elements afterward. In the above example, we re-wired the data cube to use an Excel table instead of an SQL one, and we matched the old FirstName column with our new FirstName column. We could now change this to use the LegalFirstName column instead.

Double-click the new Tabular Select to configure it, then scroll down and click Edit input elements.

Click Edit input elements
Click Edit input elements

Notice above that LegalFirstName is currently unused from our example. We can locate FirstName in the Connector Name column and change the drop down to select LegalFirstName.

Select another source element
Select another source element

Submit the dialog.

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.

3. Re-wire metric set elements

To replace the data cube used behind a metric set, open it in the full-screen editor from the main menu or from its Data Analysis Panel.

In the toolbar, choose Data Tools, then Replace Source Cube.

Edit the metric set to replace its source cube
Edit the metric set to replace its source cube

Select the new source data cube and click the submit button at the bottom of the dialog.

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

Submit the dialog when done.

A dialog will appear confirming that the source was replaced. The metric set's elements and their settings remain intact.

Observe the result
Observe the result

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

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