Vidas Matelis Analysis Services Blog

I pre-ordered “Microsoft SQL Server 2008 Analysis Services Unleashed” (Amazon links: US, UK and Canada) some time ago and today I finally received it. The authors are Irina Gorbach, Alexander Berger and Edward Melomed. This book is the second edition of the older book “Microsoft SQL Server 2005 Analysis Services” (Amazon links: US, UK and Canada). It has the same structure as the older book – the same 9 parts, but the 41 chapters are slightly different.

Read the rest of this entry »

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 »