SSAS: Automating the Scripting of an SSAS database
User Rating: / 0
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 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.





XL Cubed