Retreive Analysis Services warning with powershell

One great feature of Analysis Services is to give warning about your cube design during the design of your cube. These warning can be retreive after you have deployed your cube on the Analysis Services Server.   here is a sample script to retreive these warning : [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”)$serverAS = New-Object Microsoft.AnalysisServices.Server$serverAS.connect(“ServerName”)$db = $serverAS.databases[“DatabaseName”] $val =…


Analysis Services and powershell

It is usefull to be able to see analysis services configuration and browsing cube structure with powershell. to achieve that, you first need to load the AMO assembly in Powershell : [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”) And then create a server object : $serverAS = New-Object Microsoft.AnalysisServices.Server And connect to your Analysis Services server : $serverAS.connect(“OPIERI02\R2”)  Now, you can…