Report Portal

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.

Read more...

Tags: management, process

 

2007-2015 VidasSoft Systems Inc.