#Objective: To get database properties of the given Analysis Server 
#Created by: MAK
#Create Date: 9/9/2007

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

## 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
{

$database = $server.Databases.Item($databasename)

if ($database.name -eq $null -or $database.name -eq "")
{
 Write-host "Database " $databasename " not found on the server $Servername"
 break

}
else
{
write-host "Server Name = " $Server.name
write-host "Database Name = " $database.Name
write-host "Database Last Schema Update = " $database.LastSchemaUpdate
write-host "Database Last Schema Update = " $database.LastProcessed
write-host "Database Cubes = " $database.cubes |select name
write-host "Database Dimensions = " $database.Dimensions | select name

}

}