|SSAS: Automating the Scripting of an SSAS database|
|Written by Darren Gosbell|
|Wednesday, 24 February 2010 00:36|
I've been meaning to post this for a little while, and a recent post on the SSAS forum at ssas-info.com prompted me to finally get around to it.
Basically the small Powershell script below will attach to the specified SSAS server and script all of the databases out to an XMLA file. In this example I also add a timestamp in the form of YYYYMMDD to the end of the file.