How do I process an individual cube partition

Question

I've got a cube set up with a number of partitions - one for each year of data in my fact table. I'd like to process partitions on an individual basis. Is this possible? If so, how do I go about this?

Thanks

Answer 1

The easiest way to process a individual partition manually is the SQL Server Management Studio, where you can simply right-click any partition and select "Process". I guess this is not what you want.

How do you process your cube in the first place? If you use SSIS for instance, you could use a script transformation to generate an XMLA script that processes the individual partition. In the simplest form the script would only take an existing XMLA and replace the name of the partition with the correct value. We have done this in a project and it works very well. The generated script can the be executed with the SSIS XMLA task as well.

If you explain your requirements in more detail maybe I can help you better.

Nicolas