Re-wire the data flow
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.
From the Explore panel, locate the replacement Excel table and drag it over the SQL Select transform.
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.
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.
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.
From the Connector Name column, locate FirstName, and use the Native Source Element Name drop-down to select LegalFirstName.
Observe that the hierarchy is still named FirstName, while the data comes from the LegalFirstName column.
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.
Create a metric set using the data cube created in the above example. From the toolbar, select Replace Source Cube.
Select the new source data cube and click Submit.
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.
Observe that the metric set is refreshed and now uses the new source data cube. The applied hierarchies and settings remain intact.
5. See also