#Objective: To create a database on the given Analysis Server 
#Created by: MAK
#Create Date: 9/9/2007

param
([string] $Servername, [string] $databasename, [string] $description)

## Add the AMO namespace
[Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") >$NULL

$server = New-Object Microsoft.AnalysisServices.Server
$server.connect($ServerName) 

if ($server.name -eq $null) {
 Write-Output ("Server '{0}' not found" -f $ServerName)
 break
}
else
{
$dbstring=$server.Databases |select-object name| select-string -simplematch $databasename

if ($dbstring)
{
 Write-host "Database " $databasename " already exist on the server $Servername"
 break
}
else
{
$server.databases.add($databasename)
$db=$server.databases.item($databasename)
$db.update()
$db.description = $description
$db.update()

}

}