Does anyone know if there's a way to have WF maintain the MAS files better if structure in the table were to change. As of now I need to go into the Reporting Server Console and make the change or refresh the synonym. Can this be automatically done? Either by creating a daily process to refresh all the MAS files or something in WF to tell it to refresh the MAS files daily.

The commands that create the synonyms are part of the FOCUS language so it should not be a problem to find a solution to your question. However, I am curious as to why you would like to do this. Changing the MFD is like changing the foundation of a house after it is built. What type of changes occur to your table structures on a daily basis?

Not so much changing the structure of the table every day. It was a curiousity question. We're doing research into using cubes with dimensions. So if we wanted to add in a new dimension or change it at some point. We wanted to know if there was a way WF can automatically detect this with human intervention.