Report Portal

About me

I work as SQL Server DBA / Developer and BI Consultant in Toronto, Canada.Canada Flag More...
Vidas Matelis picture

Search

blank

Powershell script to process SSAS database objects

December 14th, 2008 by Vidas Matelis

I recently posted a new PowerShell script to process all dimensions and cubes in the specified Analysis Services database. This script has a few additional parameters that give you more control for your SSAS DB processing. First of all, you can specify the MaxParallel processing parameter to control the level of parallelism. You can also specify how many processing commands you want to execute per batch.  Read the rest of this entry »

Posted in PowerShell, SSAS | Comments Off on Powershell script to process SSAS database objects

Powershell scripts to process dimensions and print SSAS DB info

November 9th, 2008 by Vidas Matelis

Previously, the majority of my scripting code was done either in the SSIS script component or in WSH. But now it is time to learn PowerShell as Microsoft included it with SQL Server 2008. I find that PowerShell has its own specific requirements – like restrictive Execution Policy or the need to load a namespace definition. I have a document where I posted my findings and links to useful PowerShell resources. I’ll keep updating that document as I learn PowerShell myself, so make sure you check it when you begin to use PowerShell. Read the rest of this entry »

Posted in PowerShell, SSAS 2008 - Katmai | Comments Off on Powershell scripts to process dimensions and print SSAS DB info