Report Portal

SSAS: Automating the Scripting of an SSAS database

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.



Tags: management, amo


2007-2015 VidasSoft Systems Inc.