Need help changing connection to a different server

Summary:

I have SmartView reports that use EPBCS Planning cube as a data source. the report has some sheet that have only one grid on a sheet, and some multigrid sheet reports. I need to point these reports to a different database that has the same naming conventions for the members, but different dimension names, and different number of dimensions. For example, in my current database, "Revenue" is a member of "Metrics" dimension, while in the new database it will be a member of "Measures" dimension. I can manually delete worksheet metadata, connect to the new server and do "Ad Hoc