How do I change the Source names in MetaMatrix?

Issue

We are using a database called Support in SQL and imported the metadata. We now have to setup additional environments and did this by adding a number to the original database, however this causes an error when trying to query the database since it is expecting Support but is now called Support_1.

So there is no way that you can set MMX to ignore the database name and only look at the layout of the database when creating a query.

It looks like it does a prefix of the database name in the query i.e.

Select * from Support.dbo.ClientDetail

We would like it to ignore the database name "Support" and just be

Select * from dbo.ClientDetail