Report Portal

Script dimensions using Windows PowerShell and AMO

...

This installment is going to illustrate how to script dimension 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.

Read more...

Tags: amo, powershell

 

2007-2015 VidasSoft Systems Inc.