Report Portal

Processing SSAS Databases Using PowerShell

Late night maintenance on databases also means I get to write a blog post during the downtime. Tonight's blog post is more PowerShell/SSAS: following on from calculating the size of dimensions and Finding Unprocessed Objects, here's a PowerShell script that will process all the databases on a given instance that match the current process state you input: If you've deployed all the databases to an instance, entering Unprocessed for $CurrentProcessState and ProcessFull for $TypeOfProcess will process all the objects. This is great for overnight batching of processing. I've also used this script to apply changes and then run a ProcessDefault on a database that is PartiallyProcessed and it seems to have worked well.

Read more...

Tags: amo, process, script

 

2007-2015 VidasSoft Systems Inc.