How to automatically refresh the schema of all analysis files in my library?

Every customer of ours has a separate folder called "customer1234". In there, they store a copy of a "template" analysis file (e.g. they modify it and then save a copy of it in their folder).

Is there a way to refresh the schema automatically (e.g. using a script or something similar)? Essentially, automating the Refresh Schema button which can be found in Data -> Data Connection Properties -> Settings. I am asking as our team will have to manually go through each of our customer's analysis files (because they all share the same data connection, it's a remote SQL server) and refresh the schema. 



 

Thank you in advance!

 

(1) Answer

Login