We use salesforce as a data connector for Dundas. Specifically, we pull fields from an "opportunity" object in salesforce. If I add fields to, or change names from the opportunity object in salesforce, all the metric sets using the salesforce data connector crash. I have to go back to the data cube, refresh it, and reconfigure all the aggregation and null replacement transforms to get it working again. Is there a way to avoid having to reconfigure the cube just because of a field update or renaming of a field from the data connector?
Why do my metric sets crash when I add fields to my data source or alter field names in my data source?
In general, data cubes should be refreshed to retrieve the latest changes in the underlying data source. By default, data cubes and other data displayed in Dundas BI are not warehoused or stored in-memory and will retrieve data directly from the data source.
Changes to the structure on which a Select transform is based, such as editing or rediscovering a data connector, require a manual refresh of the transform. Simply right-click the Select transform node and select Refresh or use the Refresh icon from the toolbar. There is an article on refreshing data in Dundas BI that you can refer to for more information.
If you set the data cube's storage type to warehouse or in-memory, you will not see the changes to the data source right away, and can control the refresh by either scheduling the re-build or triggering it via a script from the dashboard.
With that said, to look into why the metric sets crash when you change something in the underlying data source, we need to review the error message. Please copy the entire error message and specify the Dundas BI version you are using. If you require some help with finding the error message or prefer not to post it publicly for some reason, please send the information to support@dundas.com and we will continue this via email.
As mentioned changing underlying structure that metric sets depends on can cause issues as the metric sets can't automatically define which structure they should depend on going forward. That being said - you do have a way to rewire metric sets to the new structure so you don't lose your work. This is detailed under http://www.dundas.com/support/learning/documentation/data-metrics/re-wire-the-data-flow