Find Unprocessed Analysis Services Objects Using PowerShell
I'm a big fan of PowerShell: every-time there's a problem I need to fix, I think "how can PowerShell help me here?" Following on from last weeks post on getting the size of dimensions, here is another PowerShell script for SSAS. This script looks for any objects that are unprocessed and writes them to the console. The script has a pause between SSAS databases so that if there is a lot of unprocessed objects you have a chance to go through them. I posted a similar but simpler script back in February that looks at the cube level for the status.
Read more...Tags: amo, process, script, powershell