Category: SSAS

Multidimensional, SSAS, Useful Scripts

SSAS database info (db size, partition size, processing status etc.)

Source:   slightly modified param($ServerName = “localhost”, $dbname = “db_name”) ## Add the AMO namespace $loadInfo = [Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”) $server = New-Object Microsoft.AnalysisServices.Server $server.connect($ServerName) if ($ -eq $null) { Write-Output (“Server ‘{0}’ not found” -f $ServerName) break } foreach ($d in $server.Databases ) { if ($d.Name -ne $dbname) { continue;Czytaj dalej / Read more

Multidimensional, SSAS

“Internal error: An unexpected exception occurred.” when trying to filter simple dimension that has ragged parent-child hierarchy in multidimensional model.

Platform: SQL Server Analysis Services 2016 RTM and later (Multidimensional)   In one of our projects, we encountered an interesting problem related to parameter filtering on one of our reports (SSRS). However, we would like to make sure that no mistake has been made before it hits as a bugCzytaj dalej / Read more