…brew your own Business Intelligence

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:

click to zoom

click to zoom

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:

click to zoom

click to zoom

From there I can right-click and select process which brings up the following screen:

click to zoom

click to zoom

From the window above, you can click OK to execute the processing job…OR you can script it out and save the XMLA script:

click to zoom

click to zoom

4 thoughts on “Process Multiple SSAS Objects Simultaneously via SSMS

  1. Richard Lee says:

    Nice. You could even stick the x,ml script in a Job and have it run at 2am or other quiet times. You know about the “process affected objects” option in Change Settings? Only really required if you have aggregation designs though.

    1. Bill says:

      Great point Richard! Admittedly I haven’t experimented much w/ “process affected objects” setting. Do you use that setting often?

  2. Ramachandran says:

    Good explanation. I was searching for processing through ssms and this helped me save some time 🙂 Thank You!

  3. Mike P says:

    THIS IS AWESOME!

Leave a Reply