We have SAC story built on DWC graphical view.
We modified one of the associated view, wherein existing hierarchy was dropped and a new hierarchy was added. (After making this change both associated view and main view were saved and deployed respectively)
On making above change SAC story threw error as expected, as the hierarchy used in story is no more present in the backend. On trying to edit the story (i.e. Add Measures/Dimensions) to include new hierarchy in place of old one, we are unable to find the new hierarchy, SAC still shows the old hierarchy name and throws an error when its used (that's obvious, hierarchy no more exist in dwc).
On adding the same view as new data source, we are able to see the new hierarchy and not the old hierarchy, but this also requires us to build the entire story from scratch, all the development made in old data source is lost.
How can we refresh the existing data source in a story so that it reflects the changes made in DWC graphical view ?