Process Multiple SSAS Objects Simultaneously via SSMS
During SSAS development, there are often times when you need to process a subset of objects (ex. dimensions, measure groups, partitions, etc) in a SSAS database. This is especially true when you’re working with a SSAS database containing multiple cubes with shared dimensions. In the past, to accomplish this task, I’d hack together a custom XMLA script and execute it (or wrapped it in an SSIS package or SQL Agent Job and execute it on a schedule).
I don’t know about you, but I hate XML and find it a real pain in the ass. Which is why, going forward, I plan on using a nifty little trick one of my teammates showed me the other day that allows you to process multiple SSAS objects simultaneously via SSMS.
The key is using the Object Explorer Details option shown below:
If you’re still using SSMS 2008, you can simply hit F7 as a shortcut to bring up the Object Explorer Details window. In SSMS 2012, it appears the shortcut has been removed and you have to access it via the menu as shown above :-/
This opens a new tab in the main SSMS pane where you can multi-select objects:
From there I can right-click and select process which brings up the following screen:
From the window above, you can click OK to execute the processing job…OR you can script it out and save the XMLA script: