Using Windows PowerShell and AMO to create an SSAS Database

Part 1 of this article series “Microsoft Windows PowerShell and SQL Server 2008 AMO” illustrated how to install Windows PowerShell and connect to an Analysis Service Servername. Part 2 [of this article illustrated how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service. Part 3 of this article illustrated how to use Windows PowerShell and AMO to get database properties of SQL Server Analysis Service. Part 4 of this article is going to illustrate how to create an Analysis Service Database using Windows PowerShell and AMO.

Let’s connect to Analysis Server using Windows PowerShell using AMO and create a database “Finance” as shown below. [Refer Figure 1.1]