Script a cube using Windows PowerShell and AMO

...

This installment is going to illustrate how to script a cube from a SQL Server Analysis Service instance to XMLA format file.

Let's begin by connecting to the Analysis Service server “PowerServer\SQL2008” using Windows PowerShell and AMO as shown below. [Refer Figure 1.0] Here you are loading the Analysis Service Manage object DLL and connecting to the Analysis Service server instance “SQL2008” on the “PowerServer3” host.